| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I format one cell based on contents in another cell in Exce
I want to shade a number of cells based on the contents of a single cell.
For example: Cell A1 = ABCD. I want cells A2, A3 and A4 to be shaded gray if A1 does not equal ABCD. Can this be done? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I format one cell based on contents in another cell in Exce
Select cells A2, A3 and A4
From the Format Menu, choose "Conditional Formatting..." Change "Cell Value Is" to "Formula Is" Enter the formula: =$A$1<"ABCD" Click the "Format" button and select your format (grey background) Click OK Click OK That should do it. HTH, Elkar "janet686" wrote: I want to shade a number of cells based on the contents of a single cell. For example: Cell A1 = ABCD. I want cells A2, A3 and A4 to be shaded gray if A1 does not equal ABCD. Can this be done? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I format one cell based on contents in another cell in
Perfect! Thanks.
"Elkar" wrote: Select cells A2, A3 and A4 From the Format Menu, choose "Conditional Formatting..." Change "Cell Value Is" to "Formula Is" Enter the formula: =$A$1<"ABCD" Click the "Format" button and select your format (grey background) Click OK Click OK That should do it. HTH, Elkar "janet686" wrote: I want to shade a number of cells based on the contents of a single cell. For example: Cell A1 = ABCD. I want cells A2, A3 and A4 to be shaded gray if A1 does not equal ABCD. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning Cell Contents of One Cell Based On Another Cell | Excel Worksheet Functions | |||
| Can I format a row based on the contents of one cell? | Excel Discussion (Misc queries) | |||
| Copy contents to cell based on value in second cell | Excel Discussion (Misc queries) | |||
| Set number format based on cell contents | Excel Discussion (Misc queries) | |||
| Conditional Format based on contents of cell. | Excel Worksheet Functions | |||
Linear Mode
