thx valco,
really appreciate ur help. what if the cell colour to be formatted (a1 in ur
ex) is text dependent?

"T. Valko" wrote:

You can do this with conditional formatting. How to do it depends on what
version of Excel you're using.

For versions prior to Excel 2007:

Select the cell in question. Let's assume this is cell A1
Goto the menu FormatConditional Formatting
Select Formula Is
Enter this formula in the box on the right:

=AND(ISNUMBER(A1),A15)

Click the Format button
Select the Patterns tab
Select the desired fill color
OK your way out

--
Biff
Microsoft Excel MVP


"Malik" wrote in message
...
I hve a formula in a cell. Is it possible that I format the cell in such a
way that if the value comes to 5, the background color changes
automatically?

Thanks