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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format does not work for some cells
Perhaps your cells are formatted incorrectly. You can try =isnumber() and
istext() to determine if what you think you are looking at is indeed what you are looking at. If the data in the cell is a value, isnumber() will return 'TRUE' and if the data in a cell is text, istext() will return 'TRUE'. Sometimes, you get those little 'tick' marks, which cause numbers to look like numbers, but the data is actually text!! Predictable, you can't perform calculations on text. Hope that helps. Regards, Ryan-- -- RyGuy "Kees Vos" wrote: 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format does not work for some cells
Thanks;
I've looked for this, but the cells were correctly. Then I also looked in my auto genereted DATA file, all the data in here was formatted incorrectly. Solved it and the formatting works! "ryguy7272" wrote: Perhaps your cells are formatted incorrectly. You can try =isnumber() and istext() to determine if what you think you are looking at is indeed what you are looking at. If the data in the cell is a value, isnumber() will return 'TRUE' and if the data in a cell is text, istext() will return 'TRUE'. Sometimes, you get those little 'tick' marks, which cause numbers to look like numbers, but the data is actually text!! Predictable, you can't perform calculations on text. Hope that helps. Regards, Ryan-- -- RyGuy "Kees Vos" wrote: 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! |
Reply |
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) |