Conditional Formatting

[antrawson]

Hi,
I am having issues with some conditional formatting.

I am wanting cells to look at a value of the cell next to it, and if it is higher than that cell turn green, if its less than that amount then turn red. Simple!Apparently not!

Column A contains the value I type in that I want to change colour
Column B contains a value that is already populated and will be either over 0 or less than 0

How can I do this without setting up each condition separately for each cell

Thanks

 

[Marcílio_Lobão]

antrawson, Good morning.

Try to use:

Select A1:A100

Conditional Format Menu --> Using Formula

Rule 1
Type: =A1 > B1
Set format fill color to GREEN
OK

Rule 2
Type: =A1 < B1<b1<b1<b1< strong="">
</b1<b1<b1<><b1< strong="">Set format fill color to RED
OK

Is that what you want?
I hope it helps.</b1<><b1< strong=""></b1<>

 

[antrawson]

antrawson, Good morning.

Try to use:

Select A1:A100

Conditional Format Menu --> Using Formula

Rule 1
Type: =A1 > B1
Set format fill color to GREEN
OK

Rule 2
Type: =A1 < B1<b1<b1<b1< strong="">
</b1<b1<b1<><b1< strong="">Set format fill color to RED
OK

Is that what you want?
I hope it helps.</b1<><b1< strong=""></b1<>

Thats perfect!! Appreciate that - such a simple one too!!

 

[Marcílio_Lobão]

antrawson,

I'm glad to have helped you.

Merry Christmas.