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-----
First click on cell R2 to make it the activecell.
Choose FormatConditional Formatting from the menu bar.
Choose the pull-down menus until they read:
'Cell Value Is equal to
Then type in the word Yes.
Click the Format button.
Use these settings to set how the cell will appear if the
assertion is true.
Click OK and then click OK again.

tod

-----Original Message-----
Hi,

How would I say this using the conditional formatting..

If R2 = Yes, then highlight H2 whatever color


Thanx,

dmorri
.

.