Conditional Formttg question

[MikeyZ]

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...?

 

[BarryL]

go to manage rules and take away the $ signs

 

[Joe4]

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.

 

[MikeyZ]

Here's what I tried.
1.

 

[BarryL]

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]

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]

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]

Correction the R should be an O.

 

[MikeyZ]

Let's try this.

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

 

[Joe4]

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.