Conditional formatting

infuseinfuse

New Member
Joined
Mar 30, 2011
Messages
3
I have these two formulas in the conditional formatting in cell B3 =AND(B3<20,$K$1="RM").....
=AND(B3>20,$K$1="RM").....
The problem is the reference is not changing when i use the format painter and copy the formula across the columns. I want the reference to change when i copy it across. like =AND(C3<20,$K$1="RM").....=AND(D3<20,$K$1="RM").....

I am using Excel 2007
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Welcome to MrExcel.

If you have those formulas they should adjust relatively when copied. If they don't make sure that you don't have any $ signs in the reference to B3.
 

infuseinfuse

New Member
Joined
Mar 30, 2011
Messages
3
It is not doing for me.. Is it working for anyone here? Can anyone check this?
Welcome to MrExcel.

If you have those formulas they should adjust relatively when copied. If they don't make sure that you don't have any $ signs in the reference to B3.
 

infuseinfuse

New Member
Joined
Mar 30, 2011
Messages
3
Sorry for the delay...Thank you Andrew. I read the link you quoted and understood how it works. My problem is solved now... Thank you once again

I think you will find that it is working, although the formula may not be what you expect when you examine it through Manage Rules. The formula that appears there is the one for the top left cell in the Applies to range. It's explained here:

http://blogs.office.com/b/microsoft.../conditional-formatting-rules-simplified.aspx

I agree that it's not particularly intuitive.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,969
Messages
5,525,961
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top