Hello all,

Could any one suggest a formula for the conditional formatting of a cell,
such that the cell is highlighted only if
a) the cell is empty and
b) the cell to its left is not blank.

For example : Cell B2 , B5 and B6 are empty but only B2 and B5 must be made
red.
A B
1 Variable Default
2 FltstCRIdlUp
3 Flt_tiCRIdlUp 2
4 PlttiCIntrIdlUp 0
5 FlstRgnIdlUp
6
7 PstRgnIdlUp1stRs _
8 lt_tiCDlyCRIdlClr -12


I have tried this

Condition1:

Cell value is equal to ="" Format Red

Condition2:

Formula is =B2<"" Format Red

I do not know where I am going wong. I am not sure, it might be very simple.

Thanks in advance

Vinay

Select B2, B5 and B6, goto CF

Add a formula of

=AND(B2="",A2<"")



--
HTH

Bob Phillips

"Vinay G" wrote in message
...
Hello all,

Could any one suggest a formula for the conditional formatting of a cell,
such that the cell is highlighted only if
a) the cell is empty and
b) the cell to its left is not blank.

For example : Cell B2 , B5 and B6 are empty but only B2 and B5 must be
made
red.
A B
1 Variable Default
2 FltstCRIdlUp
3 Flt_tiCRIdlUp 2
4 PlttiCIntrIdlUp 0
5 FlstRgnIdlUp
6
7 PstRgnIdlUp1stRs _
8 lt_tiCDlyCRIdlClr -12


I have tried this

Condition1:

Cell value is equal to ="" Format Red

Condition2:

Formula is =B2<"" Format Red

I do not know where I am going wong. I am not sure, it might be very
simple.

Thanks in advance

Vinay