I am trying to create a Conditional Formatting to visually show the status of Procedures that are being documented.
Column F will show whether a Procedure has been documented yet or not. If it has it will show "Y", if not it will show "N"
So in Column G, I want a Green light to appear if F= "Y"
and a Red light to appear if F = "N"
Here is what I have tried, and nothing happens. No light appears in the cell at all.
In Column G I entered the following formula; =IF(F5="Y","2",IF(F5="N","1",""))
Then I added a new rule to show:
Green Light when value is > = 2
Red Light when <2 and < = 1
What am I doing wrong? Why does an icon not appear at all on the cell after I do the Conditional Formatting?
Please Help
Bookmarks