Applying Conditional Formatting without overwriting existing formatting

TGreenwood

New Member
Joined
Nov 5, 2020
Messages
7
Office Version
  1. 365
Platform
  1. Windows
Good morning

I am trying to set up conditional formatting on a spreadsheet. I've it set up correctly on the top row, and wish to apply it to the rest of the sheet.
However, I don't want to simply drag it down as it overwrites the existing formatting (not conditional).
Is there any way I can get the Conditional Formatting to apply to the rest of the sheet using a method other than the standard copy/paste/Format Painter etc?

Format Rule:
=$D13='Audit Exam task'!$H$3:$H$5

Applies to:
=$A$13:$S$13

I need it to cover every row on the sheet. I am aware that if the formula is true, it will overwrite the formatting, which I am fine with.

Thank you
 

Attachments

  • Audit Test Sheet.JPG
    Audit Test Sheet.JPG
    187.1 KB · Views: 5

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,819
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
That looks fine to me then. Do you have calculation on automatic?
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

TGreenwood

New Member
Joined
Nov 5, 2020
Messages
7
Office Version
  1. 365
Platform
  1. Windows
Hang on a minute! It's suddenly decided to work!
(Think I'm having server issues which might be affecting my work.)
Thank you so much!!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,800
Messages
5,574,402
Members
412,590
Latest member
Velly
Top