| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Formatting Formula
Hi,
How would I say this using the conditional formatting.. If R2 = Yes, then highlight H2 whatever color Thanx, dmorri |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting Formula
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting Formula
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 . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting Formula
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 . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting Formula
Select cell H2 and then do the conditional format
-- Don Guillett SalesAid Software "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 . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting Formula
Thank you very much
:) -----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 . |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting Formula
glad to help
-- Don Guillett SalesAid Software "dmorri" wrote in message ... Thank you very much :) -----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 . |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting Formula
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 . |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting Formula
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 . . |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Conditional Formatting Formula
Hi
- select cell H2 - goto the conditional format dialog - enter the FORMULA: =$R$2="Yes" - choose your font -----Original 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----- 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 . . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using an If Formula with Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting Formula using AND | Excel Worksheet Functions | |||
| Conditional Formatting Formula | Excel Worksheet Functions | |||
| Conditional Formatting Formula | Excel Worksheet Functions | |||
| %formula in conditional formatting | Excel Worksheet Functions | |||
Hybrid Mode
