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 if another cell contains specific text ✓ - Excel Forum
Clear only the formatting from the selected cell (leaving the content) - Guide
If cell contains specific text then return value in another cell ✓ - Excel Forum
If cell contains date then return value ✓ - Office Software Forum
Apply conditional formatting to the selected cells ✓ - 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

How to use conditional format based on text?

Highlight cell if another cell contains specific text

help me to add particular cells

Excel - IF function with multiple words

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!