Conditional Formatting if any value in the cell
 

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

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

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

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" wrote in message
...
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

Bob,

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

Thanks
Alex

"Bob Phillips" wrote:

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" wrote in message
...
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

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)


"Metallo" wrote in message
...
Bob,

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

Thanks
Alex

"Bob Phillips" wrote:

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" wrote in message
...
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