Conditional formatting from another cell by range

Solved/Closed

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

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 function in cell b2 to display the current date from your system. ✓ - Excel Forum
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

1 response

Answer 1 / 1

Blocked Profile
Feb 13, 2014 at 09:42 AM

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

Copy range data in a column to new column.

range of numbers

Similar discussions

Subscribe To Our Newsletter!