| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Based of Cells Based on Data Entry in anoth
I would like to type in data in one cell that would change the cell color of
other cells that match the data in the 1st cell. I.e. Typing XXX in Cell A1 would highlight all cells with XXX in them. Is that possible in Excel 2003? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting Based of Cells Based on Data Entry in anoth
Hi,
Select all the cells which you want to format his way. Suppose cell A1 contains the value you want to control the formatting. Choose Format, Conditional Formatting, and from the second drop down pick equal to, in the third box type =$A$1 Click the Format button and pick a color on the Patterns tab, click OK twice If this helps, please click the Yes button -- Thanks, Shane Devenshire "Jim" wrote: I would like to type in data in one cell that would change the cell color of other cells that match the data in the 1st cell. I.e. Typing XXX in Cell A1 would highlight all cells with XXX in them. Is that possible in Excel 2003? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting Based of Cells Based on Data Entry in a
Outstanding and thank you!
"ShaneDevenshire" wrote: Hi, Select all the cells which you want to format his way. Suppose cell A1 contains the value you want to control the formatting. Choose Format, Conditional Formatting, and from the second drop down pick equal to, in the third box type =$A$1 Click the Format button and pick a color on the Patterns tab, click OK twice If this helps, please click the Yes button -- Thanks, Shane Devenshire "Jim" wrote: I would like to type in data in one cell that would change the cell color of other cells that match the data in the 1st cell. I.e. Typing XXX in Cell A1 would highlight all cells with XXX in them. Is that possible in Excel 2003? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting Based of Cells Based on Data Entry in a
Glad to help!
-- Thanks, Shane Devenshire "Jim" wrote: Outstanding and thank you! "ShaneDevenshire" wrote: Hi, Select all the cells which you want to format his way. Suppose cell A1 contains the value you want to control the formatting. Choose Format, Conditional Formatting, and from the second drop down pick equal to, in the third box type =$A$1 Click the Format button and pick a color on the Patterns tab, click OK twice If this helps, please click the Yes button -- Thanks, Shane Devenshire "Jim" wrote: I would like to type in data in one cell that would change the cell color of other cells that match the data in the 1st cell. I.e. Typing XXX in Cell A1 would highlight all cells with XXX in them. Is that possible in Excel 2003? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting based on the sum of two cells (Excel 2007) | Excel Discussion (Misc queries) | |||
| Conditional Formatting Based on two cells in a row | Excel Worksheet Functions | |||
| counting cells based on conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on other cells | Excel Worksheet Functions | |||
| Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
Linear Mode
