If cel in next colum same row = less color red

  • Thread starter Thread starter Nelson
  • Start date Start date
N

Nelson

Good day, I am not sure if conditional formatting will work with this but
here is what I am looking for

I have 2 columns H and I. H has previous years sales numbers and I has
current years.

I want to select all of column I and say if cell in H (same row) is less
than I turn I column red

Any suggestions

Thanks
 
1. Select the cell/Range
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=I1<H1

4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK


If this post helps click Yes
 
This wont work, I need to say that if I1>H1 turn red and if I2>H2, I3>H3, so
on and so on.

Can this be done without having to set a conditional format on each row?
 
You dont need to set that in each row.

--Select Column I. The highlighted cell should be I1. (background would be
white)
--Now from menu Format>Conditional Formatting> enter the formula...
--Even if the formula refers to the first cell; conditional formatting is
applied to all cells in the selection.

Try and feedback

If this post helps click Yes
 
Did you try before you said it won't work?

You need to have a look at the help files on "relative and absolute cell
references" and see how Excel will increment a cell address throughout a
selection of cells.

Just for practice........forget CF

Enter =A1 in B1

Drag/copy down to B10

Check each cell to see how the A1 reference increments.

Formulas in CF do the same thing.


Gord Dibben MS Excel MVP
 
Back
Top