Conditional Formatting if any value in the cell

[Metallo]

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

 

[Bob Phillips]

Use a formula of

=a1<>""

--

HTH

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

 

[Metallo]

Bob,

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

Thanks
Alex

 

[Bob Phillips]

Select the cell, goto CF, change condition1 to Formula Is, click Format and
select a colour from the pattern tab.

--

HTH

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

 

[Metallo]

Bob,

That I had understood, but what I dont understand is the meaning of =a1<>""

Thanks
Alex

 

[Bob Phillips]

It is testing cell A1 for no value. SO it can have a formula that evaluates
to nothing and still trigger CF.

--

HTH

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