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
Based on the values in cells b77 b88 - Excel Forum
Excel conditional formatting if another cell contains specific text - Excel Forum
Cell phone codes - Guide

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

help me to add particular cells

How to use conditional format based on text?

Fill adjacent cell with number from text answer

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

Excel function question

Similar discussions

Subscribe To Our Newsletter!