| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format does not work for some cells
Hey,
I have a excel file with sales amounts per week per item. This file is automatically update from a different auto generated file. With formulas like ='G:\xxx\Sales\Delivery schedules\[DATA.xlsx]Blad1'!E3 each cell is filled. With this data I create new views like what is in stock (of items in order), when I have to deliver a part, etc. The problem is that some cells are not affected by conditional formatting. When I change the formula to a hard number, the cell is affected. Any idea how I can fix it? Thanx! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom format date cells-Autofilter doesn't work right | Excel Discussion (Misc queries) | |||
| How can I format unlocked cells when the work sheet is protected | Excel Discussion (Misc queries) | |||
| Conditional format for cells. | New Users to Excel | |||
| In Excel 2003, why does the format cells option not work? | Excel Discussion (Misc queries) | |||
| In Excel 2003, why does the format cells option not work? | Excel Discussion (Misc queries) | |||
Threaded Mode
