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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting 1
Conditional formating 4
conditional statement help 4
Conditional formatting if three conditions are true 1
Conditional Formatting based on dynamic Date 1
Conditional Formatting 1
CONDITIONAL FORMATTING QUERY 0
How-to apply conditional format 1

Back
Top