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

1 reply

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!
0