Previous Topic Next Topic

Conditional Formatting of one cell based on the other cell.

Closed
Dmitry - Nov 5, 2015 at 06:37 AM
nogapok1 Posts 1 Registration date Thursday November 5, 2015 Status Member Last seen November 5, 2015 - Nov 5, 2015 at 08:40 AM
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

Answer 1 / 1
Rapstorm Posts 7 Status Member
Nov 5, 2015 at 08:16 AM
Hi There,

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

Rapstorm
nogapok1 Posts 1 Registration date Thursday November 5, 2015 Status Member Last seen November 5, 2015
Nov 5, 2015 at 08:40 AM
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.

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Conditional formatting based text in another cell
y88y -
y88y -

2 responses