# Conditional Formttg question

#### MikeyZ

##### Well-known Member
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...?

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
go to manage rules and take away the \$ signs

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.

Here's what I tried.
1.

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.

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.

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.

Correction the R should be an O.

Let's try this.

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

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.

Replies
2
Views
169
Replies
3
Views
462
Replies
3
Views
334
Replies
9
Views
243
Replies
0
Views
81

1,216,126
Messages
6,129,016
Members
449,480
Latest member
yesitisasport

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

### Which adblocker are you using?

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

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