If cel in next colum same row = less color red

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
 
J

Jacob Skaria

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
 
N

Nelson

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

Jacob Skaria

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
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top