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
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
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
Related:
- Conditional format based on cell containing function
- Format factory - Download - Other
- Kingston format utility - Download - Storage
- Find function on mac - Guide
- Marksheet format in excel - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
3 responses
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
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
simy100
Posts
2
Registration date
Wednesday January 22, 2014
Status
Member
Last seen
January 23, 2014
Jan 23, 2014 at 02:51 AM
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.
