Conditional formatting from another cell by range [Solved/Closed]

Report
Posts
1
Registration date
Thursday February 13, 2014
Status
Member
Last seen
February 13, 2014
-
 Blocked Profile -
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


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!