Conditional formatting

Resolved · Low Priority · Version 2003

Fri 25 Jul 2008, 15:54 Delegate Paul said...

Paul has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Excel VBA Advanced course

Conditional formatting

How do you copy conditional formatting for whole row based on a cell within the row

Wed 30 Jul 2008, 14:15 Trainer Simon said...

RE: conditional formatting

Hi Paul,

Thank you for your question.

Select the cell with the Conditional formatting on and use the format painter to paint it onto the other cells in the rows.

I hope this answers your question.

Regards

Simon

Excel tip:

Creating custom lists

In Excel if you type in January in a cell, you can then copy this cell to replicate Febraury, MArch, April etc.

This list has come from Tools- options and Custom lists.

Therefore to save time and create your own list you can click on New (in Tools and custom list tab) and type out the lsit that you want copied quickly.

All you have to do is then type in the 1st word and you will be able to copy the rest of the list quickly.

View all Excel hints and tips

Conditional formatting

Conditional formatting

RE: conditional formatting

Excel articles

Excel tip:

Creating custom lists