Cell color based on value

[ignus99]

could someone tell me the code to change the color of a cell based on what the number is? such as... if the number is above 3, change it to red

thank you in advance

[swatsp0p]

Use Format>Conditional Formatting...

Condition1:

Cell Value Is | greater than | 3

click Format and choose the pattern tab to set the fill color


This can be used for up to 3 conditions (use ADD>> for more)

HTH

Bruce

[ignus99]

Thanks a bunch... im really new at excel