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
Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names. ✓ - Excel Forum
Apple airtag range - Guide
Insert a function in cell b2 to display the current date from your system. ✓ - Excel 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!