Cell Color

jbechtle

New Member
Joined
Jun 22, 2004
Messages
5
I'm looking for a macro that will change to color of a cell when you have a specifc value in the cell. 91%-100% = green 81%-90% = Yellow 71%-80% = red.
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,870
Hi jbechtle

Maybe you don't need a macro.

Take a look at Format>Conditional Formatting

HTH
PGC
 

Watch MrExcel Video

Forum statistics

Threads
1,113,862
Messages
5,544,728
Members
410,630
Latest member
JFORTH97
Top