Solved: Conditional Formatting

I am trying to use Conditional Formatting and have run into a snag. I have a column that is comprised of cells containing a formula that renders the cell BLANK until a date is entered in the Date field in the corresponding row. At that point, the value is either 0 or >0.

So, the range in question has three possible values, BLANK (actually contains a formula), 0 or >0.

First Condition:
If the cell value >0, I have Conditional Formatting configured to changed the background color to red and the font color to white.

Second Condition:
If the cell value is blank, I have a formula, i.e., =MOD(ROW(),2)=1, inserted to alternate the row color based on whether the row number is an odd or even number.

Both of these conditions work as intended; however, the First Condition is also effecting the BLANK cells as if the value is greater than 0, presumably because the cell contains a formula, even though there is no content displayed.

How can I add a new condition (or modify an existing condition) to force the Second Condition to apply to the cells whose formulas result in them being BLANK?

Thanks,

Opv

Hi
Please attach the sheet to see and help you out...
:help

Quote:

---

Originally Posted by Mis_Sailesh

Hi
Please attach the sheet to see and help you out...
:help

---

Here you go....

Thanks,

Opv

Hi
Please see the attached file .
Kindly revert if it servers your pupose...


I have modified the formula in conditional formating to :-

"=IF(D2<>"",IF(D2>0,TRUE,FALSE),FALSE)"

:help

Attachment 3172

Quote:

---

Originally Posted by Mis_Sailesh

Hi
Please see the attached file .
Kindly revert if it servers your pupose...


I have modified the formula in conditional formating to :-

"=IF(D2<>"",IF(D2>0,TRUE,FALSE),FALSE)"

:help

---

That did the trick. I appreciate the help.

Opv

Please Mark your thread as Solved

Thank you...

:help