Conditional Formatting Not Functioning Correctly

mmac723

New Member
Joined
Jun 18, 2019
Messages
12
I've created formulas for my conditional formatting, and it works in the first sheet. I've then used the format painter to apply the Conditional Formatting to another sheet - and it's turned my whole sheet green!
The rule is not being followed - any ideas?
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
I've created formulas for my , and it works in the first sheet. I've then used the format painter to apply the Conditional Formatting to another sheet - and it's turned my whole sheet green!
The rule is not being followed - any ideas?

You can put the formula you have in the conditional formatting on each sheet and what do you have in apply to
 
Upvote 0
I've created formulas for my conditional formatting, and it works in the first sheet. I've then used the format painter to apply the Conditional Formatting to another sheet - and it's turned my whole sheet green!
The rule is not being followed - any ideas?

it's because your conditions in the new sheet are not in the same place, so your condition field on the new formatting is having no restriction based on what field it's actually pointing to. Manage rules in conditional formatting and choose the one on the sheet your having a problem with, and look at the cells it's referencing

(either due to having relative references and not pasting the formatting in the same cells on the other sheet, or having absolute references that do not match up on both sheets)
 
Last edited:
Upvote 0
You can put the formula you have in the conditional formatting on each sheet and what do you have in apply to

The formula is =$L7="Scheduled on OAP" > Format Green> Applies to: =$A$7:$U$505

But the cell in Column L is blank, yet it is still turning ever row green.
Other formatting supersedes it, so if I put in another data point, it will revert to grey or orange, or whathaveyou.
I just don't want a totally green spreadsheet....
 
Upvote 0
I've checked, and the rules apply to to correct cells -
My issue (which I don't think I made clear) is that the cell is blank, and its still turning green.
Maybe I'm missing something super simple, but I cant seem to keep the rules in place and have a non-green spreadsheet.
 
Upvote 0
I have always found the Format Painter to be a bit flaky/unpredictable when it comes to Conditional Formatting.
Your formulas look pretty basic. I would recommend just writing them directly to your other sheets instead of trying to use the Format Painter.
 
Upvote 0
I have always found the Format Painter to be a bit flaky/unpredictable when it comes to Conditional Formatting.
Your formulas look pretty basic. I would recommend just writing them directly to your other sheets instead of trying to use the Format Painter.


I'm going to sound lazy here - but there are 28 conditions and 52 tabs that need application of formatting.
I'm trying to find an easy fix - it's totally possible to do individually, but I'm dreading it....
 
Upvote 0
Try using the Macro Recorder as you do it to one tab, and record the setting of those rules.
You should then be able to use that code to set it up on all tabs (it may require a little fine tuning, depending on the differences in your sheets - but if there are differences, than the Format Painter probably wouldn't work anyway).
 
Upvote 0
The formula is =$L7="Scheduled on OAP" > Format Green> Applies to: =$A$7:$U$505

But the cell in Column L is blank, yet it is still turning ever row green.
Other formatting supersedes it, so if I put in another data point, it will revert to grey or orange, or whathaveyou.
I just don't want a totally green spreadsheet....

I tried your Conditional Formatting and it works. You comment that you have other Conditional Formatting, you could put them to review them together.
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,287
Members
448,562
Latest member
Flashbond

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