Hi all excel masters!
I got a problem with setting conditional formatting, please see attached workbook.
The rules I want to set:
if number of rejections is above 5 - change cell colour to red (done that)
if number of rejections is between zero and 5 - change cell colour to green (done that as well).
The problem I am having is that empty cells (for future weeks) are coloured green as well, I would like them to remain white.
Please help!
Amended version attached.
I've used an AND formula to change one of the conditional formats.
So if the cell is blank it stays white.
If I've been of help, please hit the star
For the green condition, use a formula
=AND(ISNUMBER(C3),C3>=0)
NOTE: Place the red condition first and green second.
HTH
Regards, Jeff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks