| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create a formula where a cell is automatically shaded ?
I want to create a formula where a cell will automatically be shaded a
certain color if a number is = a certain number |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create a formula where a cell is automatically shaded ?
Select the cell or cells that you want to shade. go to FORMAT-CONDITIONAL
FORMATING. Use the drop down box to choose greater than or equal to, in the right most box enter the value Click the format button to pick the shading you want. Click Okay and you are done. Formula example "Rafi2288" wrote: I want to create a formula where a cell will automatically be shaded a certain color if a number is = a certain number |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| why doesnt my formula cell update automatically ? | Excel Discussion (Misc queries) | |||
| Cell Ref. in Formula changes automatically | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Automatically Converting Formula in a Cell to its Value at the End of the Day | Excel Worksheet Functions | |||
| how do i create a blank cell in excel using a formula | Excel Worksheet Functions | |||
Linear Mode
