Hi,
I am trying to create a conditional format but to read to sets of data to determine the colour it will show...
So, the first line "YES" or "NO" and the second a number.
If the cell in row 6 shows "YES" then i would like have the number cell to be filled green below 30, orange between 30-49 and red 50 and above.
If the cell in row 6 shows "NO" then i would like the number cell to be filled green below 20 and red 20 and above.
If the cell in row 6 shows "N/A" then i would like the number cell to be filled green below 20 and red 20 and above.
I have attached a mock sheet for you to see what i am talking about.
I'm not even sure if this is possible...
Hope you can help me on this one.
Thanks in advance!
Bookmarks