Conditional Formatting of one cell based on the other cell.

Closed
Dmitry - 5 Nov 2015 à 06:37
nogapok1 Posts 1 Registration date Thursday 5 November 2015 Status Member Last seen 5 November 2015 - 5 Nov 2015 à 08:40
Hello,

I was wondering if there is a way I can say to excel without coding:

I have three cells A1, B1 and C1. If A1 value (which constatly changes automatically) is equal or greater than B1, I want a red background in cell A1. On the other hand, if A1 value is equal or less than C1, I want a green background in cell A1. If A1 value is inbetween B1 and C1 I want it to have no background fill.

Note: B1 and C1 values will never intersect (B1 is always higher number than C1).


Related:

1 response

Rapstorm Posts 7 Status Member
5 Nov 2015 à 08:16
Hi There,

I'd use something like this. I hope this helps you.

Rapstorm
nogapok1 Posts 1 Registration date Thursday 5 November 2015 Status Member Last seen 5 November 2015
5 Nov 2015 à 08:40
Thank you for your reply. That is what I have at the moment,but if I want to change B1 and C1 values I cannot just go to cell and change, I need to change rule which will take considerably longer than just changing cell value.