Conditional Formttg question

MikeyZ

Well-known Member
Joined
Mar 14, 2002
Messages
553
In O10 I set a conditional format as follows:
=O10>N10
Change the Font to a red color.
Then I click on the PaintBrush to set the format for the rest of the 5000 lines.

When I go to O11 to check the format it says =O11>N11.
When I go to O12:O5000 to check they all say =O11>N11.

Is this normal or do I need to set more paraneters...?
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,916
Office Version
  1. 365
Platform
  1. Windows
When I go to O12:O5000 to check they all say =O11>N11
Are you looking at the whole range at once when you see this, or just an individual cell?
Sometimes it is presented a little funny, but works as it should.
Take a look at just cell O12 by itself and see what it looks like.
Then make entries in O12 and N12 to test it out.
If it works as you expect, then you are good.
 

BarryL

Well-known Member
Joined
Jan 20, 2014
Messages
1,421

ADVERTISEMENT

if you go into conditional formatting->manage rules

look at your formula under Rule (applied in order shown)

does it have $ in the formula?

if so double click on it, take out the $ signs and press apply.
 

MikeyZ

Well-known Member
Joined
Mar 14, 2002
Messages
553
What I ended up doing was set O10, then double clicked the Pain Brush and clicked on O112 and each cell all the way to the bottom.
Then checked each cell and the formatting was right. But I'm sure that's the wrong way to do it.

Then I tried selecting O10:O50 as a test.
Set the formula in CF to =O10>N10 and set it that way.
It didn't work. I tried removing $ and that didn't work.
 

MikeyZ

Well-known Member
Joined
Mar 14, 2002
Messages
553

ADVERTISEMENT

I went back into CF - Manage Rules and this is what is in the Applies To box: =$R$12
I tried removing the $$ and it let me, but when I went back in it was set to =$R$12 again.
 

MikeyZ

Well-known Member
Joined
Mar 14, 2002
Messages
553
Let's try this.

How would you set the Formating for the entire Column "O" for O10:O5000.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
55,916
Office Version
  1. 365
Platform
  1. Windows
Let's try this.

How would you set the Formating for the entire Column "O" for O10:O5000.
The way I do it is to highlight the entire range you want to apply the Conditional Formatting to, then write the formula is it pertains to the first cell only (be sure NOT to use any "$"). It will automatically adjust for all the other cells.

I find that this works better than the Format Painter.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,463
Messages
5,596,284
Members
414,051
Latest member
tabecker

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
Top