G Guest Aug 12, 2004 #1 I would like to have a cell either shade green or red when a certain name is placed in a column? Simple
I would like to have a cell either shade green or red when a certain name is placed in a column? Simple
F Frank Kabel Aug 12, 2004 #2 Hi have a look at 'Format - Conditional Format. See: http://www.cpearson.com/excel/cformatting.htm
A Andy Brown Aug 12, 2004 #3 I would like to have a cell either shade green or red when a certain name is placed in a column? Simple Click to expand... ??? ; green for a certain name, red for a certain other name? Try 2 conditional formatting formulas, such as =MATCH("Name1",$C:$C,0) & =MATCH("Name2",$C:$C,0) HTH, Andy
I would like to have a cell either shade green or red when a certain name is placed in a column? Simple Click to expand... ??? ; green for a certain name, red for a certain other name? Try 2 conditional formatting formulas, such as =MATCH("Name1",$C:$C,0) & =MATCH("Name2",$C:$C,0) HTH, Andy
A Andrew P Aug 12, 2004 #4 use conditional format from format drop down - select cell value and equals to - type the word you want select the font and away you go. Thanks Andrew
use conditional format from format drop down - select cell value and equals to - type the word you want select the font and away you go. Thanks Andrew
