Conditional formatting from another cell by range

Solved/Closed

riboss Posts 1 Registration date Thursday 13 February 2014 Status Member Last seen 13 February 2014 - 13 Feb 2014 à 07:13
Blocked Profile - 13 Feb 2014 à 09:42

Hey,

I need helpppppppp

i want to change the color of a cell based on the range value of another cell
eg. i need a1 to be red if b1 is < 70%, Yellow if b1 is > 70% but < 85 and green if b1 is >85%

anyone?

thanks

Conditional formatting from another cell by range
Excel conditional formatting based on date - Guide
Clear only the formatting from the selected cell - Guide
How to increase wifi range from router settings - Guide
Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
Range of numbers ✓ - Excel Forum

1 response

Réponse 1 / 1

Blocked Profile
13 Feb 2014 à 09:42

Ok, so where are you having problems? Just reference the cellyou wish to change in th eformula, like :

Notice the stop if true!

I hope I am not doing homework!

Have fun!

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 Macro - Set and autofill a range?

Excel - IF function with multiple words

Similar discussions

Subscribe To Our Newsletter!