conditional formatting

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

Conditional formatting

resolvedResolved · Low Priority · Version 2003

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

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


Server loaded in 0.08 secs.