Conditional formatting in multiple cells

[Ed Smega]

In Excell 2007 I can do conditional formatting in a single cell, but if I
select multiple cells the conditional formatting doesn't work. Is this by
design, Is it broken or do I need to do something special?

Ed

 

[Chip Pearson]

If you are using the "Formula Is" conditional formatting, Excel will
automatically adjust row and column references. For example, if you
select J1:K1 and enter a formula like the following in the conditional
formatting dialog,

=IF(A1="Yes",TRUE,FALSE)

The A1 will be A1 in the formula in J1, but will be B1 in the K1
formula. To prevent this, use absolute references in the formula:

=IF($A$1="Yes",TRUE,FALSE)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[DILipandey]

Hi Smega,

One way could be, select the cell in which you have done the conditional
formatting. Now using CTRL, select the rest of the cells in which you need
to apply the conditional formatting and press the following key combination:-
Alt + O + D
and the press "Enter"
What it will do, it will paste the conditional formatting to the rest of the
selected cells as well (Please note that the rest of the cells should not
have any conditional formatting set already, if they have so then you might
need to delete the conditional formatting before proceeding)
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India