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
Apple airtag range - Guide
Excel formula to subtract one cell from another - Excel Forum
If cell contains date then return value ✓ - Office Software Forum
Phone formatting software for pc - Download - File management

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

Highlight cell if another cell contains specific text

How to use conditional format based on text?

help me to add particular cells

Excel Macro/Code help: Creating sheet for each name in column of another sheet

If a cell contains any text then add a value

Similar discussions

Subscribe To Our Newsletter!