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

for cell g1 formula is
=h1="no"

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Greg Snidow" <(E-Mail Removed)> wrote in message
news:08A60922-2BE1-48EF-984E-(E-Mail Removed)...
> 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 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

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