| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color filled in auto but from where
i have a spreadsheet that another person created for Project managemet of
dates over multiple release schedules. There is a formula =IF(AND(EG$2=$B109, EG$2<=$C109),1,"") that places 1s or blanks in each cell. Then something colors in each cell that has a 1 in it. I can't find what is doing that. Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Color filled in auto but from where
See if there is something under Format...Conditional formating...
"Cindi" wrote: i have a spreadsheet that another person created for Project managemet of dates over multiple release schedules. There is a formula =IF(AND(EG$2=$B109, EG$2<=$C109),1,"") that places 1s or blanks in each cell. Then something colors in each cell that has a 1 in it. I can't find what is doing that. Any ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Color filled in auto but from where
Thank you Gerry that was it. Yeah!!!!!!!
"GerryK" wrote: See if there is something under Format...Conditional formating... "Cindi" wrote: i have a spreadsheet that another person created for Project managemet of dates over multiple release schedules. There is a formula =IF(AND(EG$2=$B109, EG$2<=$C109),1,"") that places 1s or blanks in each cell. Then something colors in each cell that has a 1 in it. I can't find what is doing that. Any ideas? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Color filled in auto but from where
Hi!
Select one of the cells in question then goto FormatConditional Formatting. You will probably see some settings there that are responsible for the behavior you're describing. Biff "Cindi" wrote in message ... i have a spreadsheet that another person created for Project managemet of dates over multiple release schedules. There is a formula =IF(AND(EG$2=$B109, EG$2<=$C109),1,"") that places 1s or blanks in each cell. Then something colors in each cell that has a 1 in it. I can't find what is doing that. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto tab- Auto fill | New Users to Excel | |||
| Running auto correct on startup? | Excel Discussion (Misc queries) | |||
| Averaging Values in Auto Filter | Excel Worksheet Functions | |||
| excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
| Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions | |||
Hybrid Mode
