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: 35
That looks fine to me then. Do you have calculation on automatic?
 
Upvote 0

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
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!!
 
Upvote 0

Forum statistics

Threads
1,214,394
Messages
6,119,262
Members
448,880
Latest member
aveternik

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top