Colour backgrounds by if function or other

[tim]

Hi I am trying to make a spreadsheet automatically colour background in a
cell based on a if function on another cell. Is this possible, or is there
another function or way of doing this?

Using Excel 2003.

thanks tim

 

[Earl Kiosterud]

Tim,

You can use Conditional Formatting with the other cell, or you can put your IF function
right in the Conditional Formatting, and you won't even need the other cell for the color
change. Say specifically what you want done, and we'll get more specific.

 

[Bernd P]

Hello Tim,

If I understand you correctly, then:
1. Look at my description of GET.CELL:
http://www.sulprobil.com/html/get_cell.html
2. Put =HasFormula into the conditional format of all relevant cells

You might want to define HasFormula as:
=GET.CELL(48,INDIRECT("RC]",FALSE))

Regards,
Bernd