Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

Conditional format based on cell containing function [Closed]

Report
Posts
2
Registration date
Wednesday January 22, 2014
Status
Member
Last seen
January 23, 2014
 -
 Blocked Profile -
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



See more

3 replies

Answer 1 / 3

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
Answer 2 / 3
Posts
2
Registration date
Wednesday January 22, 2014
Status
Member
Last seen
January 23, 2014
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.
Answer 3 / 3

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:


Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!