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.
Clear only the formatting from the selected cell (leaving the content) - Guide
If a cell has text then return value ✓ - Excel Forum
Count if cell contains number - Excel Forum
If cell contains date then return value ✓ - Office Software Forum
Based on the values in cells b77 ✓ - Excel Forum

1 response

Answer 1 / 1

Rapstorm Posts 7 Registration date Thursday November 5, 2015 Status Member Last seen November 6, 2015
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

Highlight cell if another cell contains specific text

help me to add particular cells

Excel function question

Fill adjacent cell with number from text answer

How to use conditional format based on text?

Similar discussions

Subscribe To Our Newsletter!