Previous Topic Next Topic

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

Réponse 1 / 1
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.

Similar discussions

Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

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

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

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

1 response