| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a cell colouring formula in Excell 2003?
Hi,
I'm trying to set a formula so that if a cell value is less than a number e.g 50 it turns the cell green and then if the value is 51 or more it turns the cell green. Is this possible, Thanks Chris |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I set up a cell colouring formula in Excell 2003?
have a look at conditional formatting under the format menu.
-- John MOS Master Instructor Office 2000, 2002 & 2003 Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Fonzy" wrote: Hi, I'm trying to set a formula so that if a cell value is less than a number e.g 50 it turns the cell green and then if the value is 51 or more it turns the cell green. Is this possible, Thanks Chris |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I set up a cell colouring formula in Excell 2003?
You may get a better idea from the response from T.Valko in this discussion
just a few posts below your original. http://www.microsoft.com/office/comm...776&sloc=en-us "Fonzy" wrote: Hi, I'm trying to set a formula so that if a cell value is less than a number e.g 50 it turns the cell green and then if the value is 51 or more it turns the cell green. Is this possible, Thanks Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Colouring A Cell Automatically with more then 3 colour choices | Excel Discussion (Misc queries) | |||
| no grid lines when colouring in a cell | Excel Discussion (Misc queries) | |||
| Automatic cell colouring | Excel Worksheet Functions | |||
| in excell the cell only displays formula, not the number | Excel Worksheet Functions | |||
| In excell 2003 I select a cell and try to refill with any color | Excel Worksheet Functions | |||
Linear Mode
