Conditional format based on cell containing function

Closed
simy100
Posts
2
Registration date
Wednesday January 22, 2014
Status
Member
Last seen
January 23, 2014
- Jan 22, 2014 at 02:42 PM
 Blocked Profile - Jan 23, 2014 at 10:09 AM
Hello,
In column J3:J32 i have functions that determinates grades (=IF(I3>=90;"10";IF(I3>=80;"9";IF(I3>=70;"8";IF(I3>=60;"7";IF(I3>=50;"6";"5")))))).
So i want to use conditional formating to colour red when grade is 5 and i dont know how. Plz help.

thanks

simy



3 replies

Blocked Profile
Jan 22, 2014 at 04:24 PM
Ok, check out this:
https://ccm.net/forum/affich-735278-conditional-formatting

I posted pictures explaining how to set formatting through built in condtional formatting tool.

Or I guess this might help:



Have Fun!

//ark
-Moderator/Contributor
0
simy100
Posts
2
Registration date
Wednesday January 22, 2014
Status
Member
Last seen
January 23, 2014

Jan 23, 2014 at 02:51 AM
Ye i've already tried that but it doesn't work :) It works if i just write 5 in a cell and use equal to 5. But when the number 5 is returned by my function conditional formatting for equal 5 just doesn't work.
0
Blocked Profile
Jan 23, 2014 at 10:09 AM
Well, make certain that you are qualifying the formatting with either a string or a number value. See if that makes a difference for you, as in:


0