How to return formatting to cells rather than value for "IF" cmnd

N

nbspacenut

Can formatting of cells be returned after an "IF" logic formula rather than a
value?
I'd like to have cells be colored when a specified cell has a specific
number entered in it when the "IF" statement is true and not colored when the
"IF" statement is false.
 
J

John C

Say you want B2 to be blue if A1 is =5

For the Conditional Format formula for B1, use the drop down box to Formula Is
=A1=5, then choose your format (blue in this case).
 

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

How to filter rows data based on background color of individual cells 1
If statement for a range of cells 3
applying conditional formatting to emtpy cells in a spreadsheet 6
Conditional Formatting Minimim Value 2
"If" statement returning blank gives downstream formula errors. 2
How to count cells colored red? 3
format cells depending on value range 5
Conditional formatting in Excel 2010 2

Top