Conditional formatting / Formula

[Rebecca Kowalski]

Hey all,

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

 

[Rebecca Kowalski]

Here's an example of the desired outcome

[TABLE="width: 245"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Date[/TD]
[TD]Data[/TD]
[/TR]
[TR]
[TD]01/09/2016[/TD]
[TD]35,064[/TD]
[/TR]
[TR]
[TD]02/09/2016[/TD]
[TD]34,836[/TD]
[/TR]
[TR]
[TD]03/09/2016[/TD]
[TD]34,836[/TD]
[/TR]
[TR]
[TD]04/09/2016[/TD]
[TD]34,836[/TD]
[/TR]
[TR]
[TD]05/09/2016[/TD]
[TD]34,631[/TD]
[/TR]
[TR]
[TD]06/09/2016[/TD]
[TD]34,645[/TD]
[/TR]
[TR]
[TD]07/09/2016[/TD]
[TD]34,642[/TD]
[/TR]
[TR]
[TD]08/09/2016[/TD]
[TD]34,439[/TD]
[/TR]
[TR]
[TD]09/09/2016[/TD]
[TD]34,452[/TD]
[/TR]
[TR]
[TD]10/09/2016[/TD]
[TD]34,452[/TD]
[/TR]
[TR]
[TD]11/09/2016[/TD]
[TD]34,452[/TD]
[/TR]
[TR]
[TD]12/09/2016[/TD]
[TD]33,774[/TD]
[/TR]
[TR]
[TD]13/09/2016[/TD]
[TD]33,606[/TD]
[/TR]
[TR]
[TD]14/09/2016[/TD]
[TD]33,525[/TD]
[/TR]
[TR]
[TD]15/09/2016[/TD]
[TD]33,333[/TD]
[/TR]
[TR]
[TD]16/09/2016[/TD]
[TD]33,249[/TD]
[/TR]
[TR]
[TD]17/09/2016[/TD]
[TD]33,249[/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcílio_Lobão]

Rebecca Kowalski, Good morning.

Supposing your VALUE data is at B2:B100

Try to use:
Select B3:B100
Conditional Format Menu --> Using Formula

Rule 1
=B3 < B2
<b2
Format: Font Color GREEN
OK

Rule 2
=B3 > B2
Format: Font Color RED
OK

Is that what you want?
I hope it helps.</b2>

 

[arthurbr]

Select range B3:B18
apply following CF =$B3>$B2 and format red
=$B3<$B2 and format green

 

[Rebecca Kowalski]

Sadly this has not worked

It may be due to I don't want to formula to always be worked against B3 I want it to be against the cell prior to the selected cell. So B4 against data is B3, then B5 against data in B4, etc...

 

[Marcílio_Lobão]

Rebecca Kowalski,

The formulas suggested in both messages act like YOU WANT.

"...It may be due to I do not want to formulate to always be worked against B3 I want it to be against the cell prior to the selected cell..."

But if you want this to happen when you select, that is to click on any cell, the others work this way, this is only possible with VBA Excel Programming.

Please, explain it a little better.
Save your Excel file at a free site, www.sendspace.com, and put a link here to download.
Remember to show us how you expect to see the result.

 

[arthurbr]

Sadly this has not worked

It may be due to I don't want to formula to always be worked against B3 I want it to be against the cell prior to the selected cell. So B4 against data is B3, then B5 against data in B4, etc...

to enter the formula for each cell, but for the entire range.
The fact that the formula is absolute for the column and relative for the row ensures that it does what you want.
It works perfectly for me as per your example
You do not have