Hello:
Please refer to attached file.
I need VB Code to apply Conditional formating on selected range as follows.
If value of cell is zero then turn to RED
If value of cell greater then zero then turn to GREEN.
Example:
I select cells B5:B31 and run code should turn B6,B11,B16,B29,B31 RED and rest of the other cells
to GREEN.
Let me know if you have any questions.
Thanks.
Riz
Bookmarks