Conditional format based on adjacent cell value
 

Greetings all. I am trying to use conditional formatting for a cell based on
the value of the adjacent cell. So, I want cell T1 to change to red if U1 =
"No". I tried Formula is =IF(U1 = "No"), but I get a formula error. Could
this be done with a Macro instead? Thank you.

Greg

Conditional format based on adjacent cell value
 

for cell g1 formula is
=h1="no"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Greg Snidow" wrote in message
...
Greetings all. I am trying to use conditional formatting for a cell based
on
the value of the adjacent cell. So, I want cell T1 to change to red if U1
=
"No". I tried Formula is =IF(U1 = "No"), but I get a formula error.
Could
this be done with a Macro instead? Thank you.

Greg

Conditional format based on adjacent cell value
 

Conditional formatting requires your formula to return a simple true or
false. To that end just get rid of the if and you are good...

=U1 = "No"
or
=upper(u1) = "NO"

makes it non case sensitive...
--
HTH...

Jim Thomlinson


"Greg Snidow" wrote:

Greetings all. I am trying to use conditional formatting for a cell based on
the value of the adjacent cell. So, I want cell T1 to change to red if U1 =
"No". I tried Formula is =IF(U1 = "No"), but I get a formula error. Could
this be done with a Macro instead? Thank you.

Greg

Conditional format based on adjacent cell value
 

Thanks Jim, that worked like a charm.

"Jim Thomlinson" wrote:

Conditional formatting requires your formula to return a simple true or
false. To that end just get rid of the if and you are good...

=U1 = "No"
or
=upper(u1) = "NO"

makes it non case sensitive...
--
HTH...

Jim Thomlinson


"Greg Snidow" wrote:

Greetings all. I am trying to use conditional formatting for a cell based on
the value of the adjacent cell. So, I want cell T1 to change to red if U1 =
"No". I tried Formula is =IF(U1 = "No"), but I get a formula error. Could
this be done with a Macro instead? Thank you.

Greg