Use if statement with conditional formatting?

  • Thread starter Thread starter q5
  • Start date Start date
Q

q5

Is it possible to use an IF statement within the conditional formatting
dialog? If so, I have not been able to figure out how to do it. Can
someone point me to an example?

Thanks.
 
Select A1.

Format|conditional formatting
formula is: =if(a1>10,true,false)

But you just need the portion that evaluates to true or false:
formula is: =a1>10

would work (and would be more common).
 
Back
Top