Bob,

I don't understand, can you be more specific?

Thanks
Alex

"Bob Phillips" wrote:

Use a formula of

=a1<""

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Metallo" wrote in message
...
Hi,

I want to apply conditional formatting if any value will appear in the
cell.
The cell has got a formula linked to another sheet, so if the other sheet
will get a value, then this is picked up in the cell, at that point, I'd
like
to have the cell to change color.

Thank you
Alex