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!

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
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response
Conditional formatting based text in another cell
y88y -
y88y -

2 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses