| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula with color fill? | Excel Worksheet Functions | |||
| Formula for a fill color help | New Users to Excel | |||
| How do you fill a cell with a color based on IFTHEN formula? | Excel Worksheet Functions | |||
| Cell Fill Color and text color - changes for recipient | Excel Discussion (Misc queries) | |||
| Color a cell and a value is automatically assigned to that color. | Excel Worksheet Functions | |||
Linear Mode
