Cell fill based on value of cell in row before

[lee2121]

Hello Everyone.

I have an excel file where i need the current cell to be filled with let's say a light red colour if the value entered into this cell is the same or less than the value in the cell above it.

For example

Cell A2 = 100 and Cell A1 = 110 then cell A2 should fill red and repeat for all other cells in the row.

I think a VBA solution may be best for this. I can do this in conditional formatting but i can't set up conditional formatting rules for each cell

The cells i need this to work on are Rows 2, 4, 6, 8 and 10

 

[lee2121]

Well maybe you should try Fluff's proposition then.
You probably misunderstood some of the instructions I gave you. I checked it again and no problem. Make sure you are referring to the correct cells in the formula.

Thank you for the reply this is how my formula looks after using the format painter.

 

[lee2121]

Well maybe you should try Fluff's proposition then.
You probably misunderstood some of the instructions I gave you. I checked it again and no problem. Make sure you are referring to the correct cells in the formula.

 

[saboh12617]

In R1C1 style the formula, i think, should be :

=R[-1]C>RC

In your formula you are referencing cells 2 columns to the left and 2/3 rows down. It's not what i indicated.

 

[lee2121]

In R1C1 style the formula, i think, should be :

=R[-1]C>RC

In your formula you are referencing cells 2 columns to the left and 2/3 rows down. It's not what i indicated.

Thank you this work perfectly, yes for some reason my excel file is using RC cell references and not the normal A, b etc. But your revised code to reflect my file worked brilliantly.

 

[saboh12617]

Glad it's solved.
To switch between A1 and R1C1 Excel – R1C1 Reference Style vs. A1