Conditional color fill

[Prof Szembor]

How can I get Excel to fill a cell with a color as a
value in an IF statement?

 

[J.E. McGimpsey]

You can't workshet functions can only return values to their calling
cells.

Look at Conditional Formatting in XL Help.

 

[Ken Wright]

You can't directly, you would need to use conditional formatting to do that, which would not
require a formula inside the cell at all.

 

[prof Szembor]

?Conditional Formatting. Help!

-----Original Message-----
You can't directly, you would need to use conditional

formatting to do that, which would not

 

[Debra Dalgleish]

There is information in Excel's online help, and on the following web page:

http://www.contextures.com/xlCondFormat01.html

If you get stuck, post again with details about your worksheet, and when
you want colours to appear.