Previous Topic Next Topic

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

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Formula to subtract one cell value from another.
autigers71 -
vcoolio -

1 response
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Excel Macro/Code help: Creating sheet for each name in column of another sheet
excelnovice2019 -
vcoolio -

21 responses