In Excel

Click on Format

Conditional Formatting

Set your first condition.

Click Add

Set your second condition.

Click Add

Set your third condition.

Click OK



"Fraggs " wrote in message
...
I have 3 scenarios, 0, <0 and =0
0, <0 = Red cells
=0 = Green cells

got a link I could look at?


---
Message posted from http://www.ExcelForum.com/