Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - For 1 cell based on contents of any cell
Hi! I'm trying to set up conditional formatting in a column heading cell
where the cell will highlight in red if any of the cells in the rest of the column have Yes in them. Example: In Cell A10, I want the cell to highlight red if any of the cells in A11 thru A100 have Yes in them. Either Yes or No will be entered in each row of the column. I'm using Excel 2003. Thanks! -- D J Hendren |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - For 1 cell based on contents of any cell
In your conditional formatting under 'Format'
Cell Value Is equal to ="yes" It's imporant that yes be in "" as it's a word. Hit the Format button Select the Pattern Tab and choose the color that you want click OK At the Conditional Formatting menu, click OK again and you should be all set. Good luck!! -- Just me! Have a safe day. "DJH" wrote: Hi! I'm trying to set up conditional formatting in a column heading cell where the cell will highlight in red if any of the cells in the rest of the column have Yes in them. Example: In Cell A10, I want the cell to highlight red if any of the cells in A11 thru A100 have Yes in them. Either Yes or No will be entered in each row of the column. I'm using Excel 2003. Thanks! -- D J Hendren |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - For 1 cell based on contents of any cell
Select A10.
Select Format Conditional Formatting. Change 'Cell Value Is' to 'Formula Is' Enter this formula in the text box: =COUNTIF($A$11:$A$100,"Yes")0 Click the Format button. Click the color Red on the Patterns tab. Click OK, then OK again. Hope this helps, Hutch "DJH" wrote: Hi! I'm trying to set up conditional formatting in a column heading cell where the cell will highlight in red if any of the cells in the rest of the column have Yes in them. Example: In Cell A10, I want the cell to highlight red if any of the cells in A11 thru A100 have Yes in them. Either Yes or No will be entered in each row of the column. I'm using Excel 2003. Thanks! -- D J Hendren |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting - For 1 cell based on contents of any c
PERFECT!!! That was exactly what I needed.
Have a terrific weekend! -- D J Hendren "Tom Hutchins" wrote: Select A10. Select Format Conditional Formatting. Change 'Cell Value Is' to 'Formula Is' Enter this formula in the text box: =COUNTIF($A$11:$A$100,"Yes")0 Click the Format button. Click the color Red on the Patterns tab. Click OK, then OK again. Hope this helps, Hutch "DJH" wrote: Hi! I'm trying to set up conditional formatting in a column heading cell where the cell will highlight in red if any of the cells in the rest of the column have Yes in them. Example: In Cell A10, I want the cell to highlight red if any of the cells in A11 thru A100 have Yes in them. Either Yes or No will be entered in each row of the column. I'm using Excel 2003. Thanks! -- D J Hendren |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting one cell based on the contents of another | Excel Discussion (Misc queries) | |||
Formatting one cell based on the contents of another cell | Excel Worksheet Functions | |||
Formatting one cell based on the contents of another | Excel Discussion (Misc queries) | |||
Return cell contents based on conditional lookup | Excel Worksheet Functions | |||
Conditional Format based on contents of cell. | Excel Worksheet Functions |