Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
Conditional formatting row when cell value is an even number | Excel Worksheet Functions | |||
Conditional formatting row if cell value in certain column is even | Excel Worksheet Functions | |||
conditional formatting blank cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |