Conditional Formatting of one cell based on the other cell.

Closed
Report
-
Posts
1
Registration date
Thursday November 5, 2015
Status
Member
Last seen
November 5, 2015
-
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).


1 reply

Posts
7
Registration date
Thursday November 5, 2015
Status
Member
Last seen
November 6, 2015

Hi There,

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

Rapstorm
0
Posts
1
Registration date
Thursday November 5, 2015
Status
Member
Last seen
November 5, 2015

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.
0