Is there an Excel function to shade cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to shade a cell a specific color dependent upon an IF statement.
ex. IF(a>b, color the cell red, color the cell green)

What (if any) is the call to change the cells color?
 
You can't use a formula to shade a cell.
What can use is conditional formatting,

Format > Conditional Formatting

select "Formula Is" in the drop down box

Enter the criteria and the required format if the criteria is true or false.

You can have upto 3 conditions
 
Hi Tommy,
This page should provide additional help you with Conditional Formatting,
It can be a little tricky getting started.
http://www.mvps.org/dmcritchie/excel/condfmt.htm

What you learn about Conditional Formatting can be applied to
Filters. and Cell Validation.

A formula cannot change the formatting of any cell, including itself.
 
Back
Top