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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Function for summing or counting cells based on a specified fill color 2
Excel Macro to automatically go to the right of the last colored cell 0
Conditional Formatting Driving Me Crazy 1
Conditional Format Based on Date 3
Excel VBA 1
Multiple Conditionals in MS Excel 2007 6
how can I use conditional formatting with formula and 3 poss resul 1

Back
Top