formula to color fill a cell if number over assigned value

  • Thread starter Thread starter rhuckeby
  • Start date Start date
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
 
Select the cell
Format -> COnditional Format
Set the conditions and format as desired.
 
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
 
Back
Top