formula to color fill a cell if number over assigned value
 

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

formula to color fill a cell if number over assigned value
 

Select the cell
Format - COnditional Format
Set the conditions and format as desired.
--
HTH,
Barb Reinhardt



"rhuckeby" wrote:

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

formula to color fill a cell if number over assigned value
 

Hi Rhuckeby

Select cell Goto FormatConditional Formatting
Condition 1
Cell Value isSelect Greater than or equal to = type 20
Click the Format button, select Patterns
Select the desired colour.
Regards
Cimjet
"rhuckeby" wrote in message
...
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