Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional formatting

Conditional formatting

ResolvedVersion 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:

Hiding and unhiding rows using the keyboard

CTRL + 9 hides your columns and CTRL + SHIFT + ( unhides them although you would need to highlight the row letters either side as per normal

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Conditional formatting

Conditional formatting

RE: conditional formatting

Excel articles

Excel tip:

Hiding and unhiding rows using the keyboard