formula to color fill a cell if number over assigned value

R

rhuckeby

I want to automatically have the cell filled with bright green if the value
present in the cell is equal to or greater than $20.00
 
B

Barb Reinhardt

Select the cell
Format -> COnditional Format
Set the conditions and format as desired.
 
C

Cimjet

Hi Rhuckeby

Select cell Goto Format>Conditional Formatting
Condition 1
Cell Value is>Select > Greater than or equal to = type 20
Click the Format button, select Patterns
Select the desired colour.
Regards
Cimjet
 
Top