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

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.

--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeyl.com
-----------------------------------------------------------------------
"tim" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> 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
>

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