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

conditional formatting

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

Conditional Formatting

ResolvedVersion 365

Nick has attended:
Excel Intermediate course

Conditional Formatting

Hello.
I have a spreadsheet with some conditional formatting for a few cells in each row, not the whole row. When I add a new row to input more data, I have to keep adding the same conditional formatting for the new information.

Is there a way that this can be done automatically without having to keep adding it each time.
Many thanks.

RE: Conditional Formatting

Hello Nick,

Thank you for your question. Depending on your version of Excel, when you insert a new row directly below a row with conditional rules, Excel automatically copies the rules to the new row. This happens in the new version of Excel (365).

If this doesn't happen, you can select and copy the cells with rules, then paste formatting to the inserted row(s).

This will transfer the rules but won't duplicate the data.

I hope this helps.

Kind regards
Marius Barnard
STL

Excel tip:

Naming and Using Constants

Constants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant.

For example:
Instead of entering 17.5% in each cell when you generate a VAT amount you could name a Constant "VAT" and assigning a "0.175" value to it. To do this:

From the 'Insert' menu select 'Name', then select 'Define'.

Enter the constant

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.