Conditional Formating for a column

  • Thread starter Thread starter gilbert
  • Start date Start date
G

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
 
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
 
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.
 
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)
 
Back
Top