Is there an Excel function to shade cells?

[Tommy]

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?

[Naz]

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

--

_______________________
Naz,
London


"Tommy" wrote:

> 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?

[David McRitchie]

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm

"Naz" <[email protected]> wrote ...
> 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
>
> --
>
> _______________________
> Naz,
> London
>
>
> "Tommy" wrote:
>
> > 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?