CONDITIONAL FORMAT a cell that has a formula in it

[Onesock]

Hi There

I have a situation where I need to format a cell based on another cells answer which is derived from a formula
I have attached a sample spread sheet to explain further .
There are 3 scenarios to my spreadsheet

A) Cell B8 is formatted 'red' when cell A8 is >0
B) Cell H8 should NOT be formatted when cell G8 is = 0
C) Cell N8 is formatted 'Green' when cell N8 is >0

So the issue is in scenario B) . Cell H8 should not be formatted .
Please could someone explain where I am going wrong , or help me with the correct CONDITIONAL FORMULA.

Thanks
Onesock

[Glenn Kennedy]

Use this:

=AND(G8>0,G8<>"")

[Onesock]

Hi Glenn

BINGO !!!
Works perfectly - THANKS !!

Onesock

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.