| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format Cell with Color
I have sells that have value of either B or S
I would like all the B cells to appear Green and all the S cells to appear Red. How can this be accomplished. -- Thanks in advance Stefan |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format Cell with Color
hi,
Conditional Formating might work. high light all the cell you wish to have this formating then on the tool bar ... Formatconditional Formating. Condition 1 - if cell Value - is equal to - ="B" - set format Patterns = Green Condition 2 - if cell Value - is equal to - ="S" - set format patterns = Red Regards FSt1 "Stefan" wrote: I have sells that have value of either B or S I would like all the B cells to appear Green and all the S cells to appear Red. How can this be accomplished. -- Thanks in advance Stefan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| Format cell color based on multiple cell values | Excel Discussion (Misc queries) | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
| format cell to change color when copied | Excel Discussion (Misc queries) | |||
Hybrid Mode
