Conditional Formatting to highlight cells help!

i need to figure out how to use conditional formatting to highlight cells which are greater than the previous cell for a set of data, any help is appreciated

My earlier response seems not to have registered. I asked if you meant the cell in the previous row or previous column. I also asked which cells you want this to apply to.

Pete

I am trying to highlight the cell if it is greater than the cell in the previous row for an entire set of data/rows

Screen Shot 2015-03-17 at 3.09.01 PM.png

this is the data set and im trying to use conditional formating as you can see but i dont know how to make it the cell value greater than the previous cell

Okay, highlight your data from A2 to wherever the bottom-most and right-most cell is, then click on Conditional Formatting | New Rule | Use a formula... from the bottom of the list, then put this formula in the dialogue box:

=A2>A1

Click the Format button | Fill tab then choose your colour and click OK twice to exit the dialogue box.

Hope this helps.

Pete

that was helpful! now i need to know how to highlight the entire row in green if the sales increase is above 10%.

Suppose your sales increase is in column H (I can't see your image as there is a problem with the Forum software). Again you need to highlight all the data and click on Conditional Formatting | New Rule | Use a formula... and then put this formula in the box:

=$H2 > 0.1

then click the Format button and select green on the Fill tab, then OK twice.

Note that there is a hierarchy for multiple CF conditions, so you may need to adjust which condition takes priority (click on CF | Manage Rules to see them both).

Hope this helps.

Pete