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
Clear only the formatting from the selected cell (leaving the content) - Guide
Apply conditional formatting to the selected cells ✓ - Excel Forum
Excel conditional formatting if another cell contains specific text - Excel Forum
If cell contains specific text then return value in another cell ✓ - Excel Forum
Excel formula to change cell color without conditional formatting - 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

Highlight cell if another cell contains any text

Excel - IF function with multiple words

one cell will turn green when the two other cells match

Similar discussions

Subscribe To Our Newsletter!