Excel Conditional Formatting

[Bill Dorn]

Does anyone know how to copy the conditional formatting of
one cell to others?

 

[Norman Harker]

Hi Bill!

Copy
Edit > Paste Special
Select Formats
OK

You can also use:
Copy
Click the Format Painter
Click the cell or drag the range to be formatted

You can also double click the Format Painter to change format of
discontiguous cells. (Click the Format Painter a second time to stop
the feature).

--
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.

 

[Paul]

Does anyone know how to copy the conditional formatting of
one cell to others?

Just as you would copy any other kind of formatting:

Edit > Copy
followed by
Edit > Paste Special, Formats

or use the Format Painter.

 

[Bob Phillips]

--

HTH

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

 

[Bob Phillips]

Bill,

Paste formats and you get CF as well.

--

HTH

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

 

[augurmaster]

i have my mp3 collection list....it has 8 column (H) and 205 row (start
with no.5)....in column H, i put just yes or no (if people select yes
then the last row will calculate how many titles people select).....how
to make when people select 'yes' then a whole selected row
coloured...?? so it can make people easy to trace what title he
selected....