lPinkFloyd
Board Regular
- Joined
- Nov 22, 2003
- Messages
- 92
I have a bizarre problem with my conditional formatting. First of all I have a sheet that has several time cards in it and the conditional formatting is working in all of them except one of them. The problem is occurring in
three of the cells. I am giving an example for only one set, but it is the same issue in the other two. The format conditions are as follows: Condition 1: If cell (xxx) value is = cell (yyy) cell color is none; Condition
2: If cell (xxx) value > cell (yyy) cell color is green; Condition 3: If cell (xxx) value < cell (yyy) cell color is red. The formulas that give me my value in cell (xxx) are correct. When I insert hypothetical data in the work
sheet to test the conditional formatting everything seems to be working, but when I enter the real data the conditional data starts acting up. For instance when cell (xxx) = (yyy) the color is red. There are three other
cells where this is happening.
I have deleted all data in these cells using delete contents, and redid the conditional formatting even going so far as to rearrange the order of the
conditions. I have double checked to make sure that I am referencing the correct cells. I did a copy from another section where the conditional formatting was working and changed the conditional formatting to make
sure I was referencing the correct cells. I tried using Format Painter and still am having the same problem. I deleted all the data and reentered it in the rest of the part of the sheet where the (xxx) gets its results from. It
seems like the main problem is with the less than part of the conditional formatting. I’ve looked around the forum but have not come across this issue. I have spent countless hours trying to make this work and as my last resort I am writing this. I know it is a long explanation for such what seems like a simple problem, but I am stuck. Using Windows XP and Office XP. Thanks
three of the cells. I am giving an example for only one set, but it is the same issue in the other two. The format conditions are as follows: Condition 1: If cell (xxx) value is = cell (yyy) cell color is none; Condition
2: If cell (xxx) value > cell (yyy) cell color is green; Condition 3: If cell (xxx) value < cell (yyy) cell color is red. The formulas that give me my value in cell (xxx) are correct. When I insert hypothetical data in the work
sheet to test the conditional formatting everything seems to be working, but when I enter the real data the conditional data starts acting up. For instance when cell (xxx) = (yyy) the color is red. There are three other
cells where this is happening.
I have deleted all data in these cells using delete contents, and redid the conditional formatting even going so far as to rearrange the order of the
conditions. I have double checked to make sure that I am referencing the correct cells. I did a copy from another section where the conditional formatting was working and changed the conditional formatting to make
sure I was referencing the correct cells. I tried using Format Painter and still am having the same problem. I deleted all the data and reentered it in the rest of the part of the sheet where the (xxx) gets its results from. It
seems like the main problem is with the less than part of the conditional formatting. I’ve looked around the forum but have not come across this issue. I have spent countless hours trying to make this work and as my last resort I am writing this. I know it is a long explanation for such what seems like a simple problem, but I am stuck. Using Windows XP and Office XP. Thanks