Conditional Formatting Formula

D

dmorri

Hi,

How would I say this using the conditional formatting..

If R2 = Yes, then highlight H2 whatever color


Thanx,

dmorri
 
T

Tod

First click on cell R2 to make it the activecell.
Choose Format>Conditional 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
 
D

dmorri

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
 
D

dmorri

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
 
F

Frank kabel

Hi
- select cell H2
- goto the conditional format dialog
- enter the FORMULA:
=$R$2="Yes"
- choose your font
 
Top