#### Rebecca Kowalski

##### New Member

- Joined
- Feb 16, 2016

- Messages
- 31

Need some advice.

I have a spreadsheet of number data with dates in ascending order in the first left column.

I want to apply a format so that for example:

If the number in Cell B3 is greater than the number in B2 (turn the text red)

If the number in Cell B3 is less than the number in B2 (turn the text green)

But I need this to be continuous, so it's the same for cell B4 against cell B3, cell B5 against cell B4 (and so forth)

Is this possible? I have tried using conditional formatting but can't get it to work on one let alone my entire spreadsheet.

Thanks

Rebecca