associates
Registered User.
- Local time
- Today, 02:33
- Joined
- Jan 5, 2006
- Messages
- 94
Hi,
I was wondering if i could get some help on some issues. I'll post two questions separately as they are different questions.
First question is I don't know if this is possible in excel. I know that we can apply conditional formatting on a single cell. is it possible to do in a range of cells.
For example, in worksheets "Data"
A1 = 20
B1 = 30
C1 = 15
A20 = 20
B20 = 30
C20 = 15
if i come along and change the value of A1 from 20 to 30, i want the whole row (in this case, row 1) to change its color to red or something to get attention of users.
is it possible? if it's, how do i do it?
Thank you in advance
I was wondering if i could get some help on some issues. I'll post two questions separately as they are different questions.
First question is I don't know if this is possible in excel. I know that we can apply conditional formatting on a single cell. is it possible to do in a range of cells.
For example, in worksheets "Data"
A1 = 20
B1 = 30
C1 = 15
A20 = 20
B20 = 30
C20 = 15
if i come along and change the value of A1 from 20 to 30, i want the whole row (in this case, row 1) to change its color to red or something to get attention of users.
is it possible? if it's, how do i do it?
Thank you in advance