Hello Excel Guru's
Please see the attached test workbook.
I have what I think is the correct conditional formatting on the column C - however not getting the desired results.
End game ... 2 possible outcomes
Have the cell turn yellow if result in cell is less than 100%
Have the cell turn red if result in cell is less than 80%
I selected the whole set of data C7:C17 and added to conditional format formulas
C7<C4 - Yellow
C7<C5 - Red
But it is not working as needed ... Where am I going wrong?
Need to do this in 4 columns all having the same 100% / 80% meet thresholds.
Thanks in advance
Bookmarks