Assigning Color in If Function

M

Mary Fetsch

In Excel 2003, can I assign color to a cell using the IF function? I want to
say "If amount > 40, make it red, otherwise keep it black". Can I do that
with IF? If not, do you know another way? Thanks!
 
T

Teethless mama

Conditional Formatting

Cell Value Is ; greater than; 40
format any color you like
 

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 extract separated text by many commas in Excel? 0
format 1
Excel VBA - counting cells by colors and names to it in two different rows. 0
How to give numbers to the font colors 2
Conditional formatting 2
Highlight Highest Amount 2
Assign a color to a cell 1
Excel 2002 count color 4

Top