Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel

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
See more

1 reply

Answer 1 / 1

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!
Ask a question