Hi dmorri,

Don's suggestion works for me.

---
Regards,
Norman




"dmorri" wrote in message
...
Sorry I must not have made this clear....I want to say..

If R2 = Yes, then highlight (H2) some color...it is H2
that I need highlighted based on what is in R2...

Thanx again
-----Original Message-----
formula is

=$r$2="yes"

and format as desired

--
Don Guillett
SalesAid Software

"dmorri" wrote in
message
...
Hi,

How would I say this using the conditional formatting..

If R2 = Yes, then highlight H2 whatever color


Thanx,

dmorri


.