Conditional Formatting Formula

[dmorri]

Hi,

How would I say this using the conditional formatting..

If R2 = Yes, then highlight H2 whatever color


Thanx,

dmorri

 

[Don Guillett]

formula is

=$r$2="yes"

and format as desired

 

[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

 

[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

 

[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

 

[Frank kabel]

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

 

[Norman Jones]

Hi dmorri,

Don's suggestion works for me.

 

[Don Guillett]

Select cell H2 and then do the conditional format

 

[dmorri]

Thank you very much

-----Original Message-----
formula is

=$r$2="yes"

and format as desired

--
Don Guillett
SalesAid Software
(e-mail address removed)



.

 

[Don Guillett]

glad to help