Conditional Formating for a column

[gilbert]

Gee...I wonder if we can create a condition formating for a column? Fo
example, say if cell A1 = Apple, then Excel will automatically colore
a range stipulated in that column red color.

Can we use If, else, then function for this?

Please advise.

Thank you.

Rgds,
Gilber

 

[Frank Kabel]

Hi
try the following
- select your cells in row 1 (e.g. A1:K1)
- goto conditional format and enter the formula
=$A1="Apple"
- choose your format

 

[Norman Harker]

Hi Gilbert!

Select the range you want to format:
Format > Conditional formatting
Formula is:
=$A$1="Apple"
Format button
Select format to taste
OK
OK

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Bob Phillips]

Gilbert,

Not a problem. Select all the cells (columns if required) to be formatted),
use CF with Condition 1 of Formula Is, a formula of =A$1="Apple" and then
format to your heart's content. All cells will pick up the appropriate
format.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)