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

Conditional Formatting of one cell based on the other cell.
Excel conditional formatting based on date - Guide
Clear only the formatting from the selected cell - Guide
Excel conditional formatting if another cell contains specific text - Excel Forum
Cell phone codes - Guide
How to insert rows in excel automatically based on cell value without vba ✓ - Excel Forum

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

help me to add particular cells

How to use conditional format based on text?

Clear cell contents based on value of another cell range using VBA

Name Values

Fill adjacent cell with number from text answer

Similar discussions

Subscribe To Our Newsletter!