Positive cells taking a zero value

[jman0707]

I have a code below to only allow a number to be entered into one of 2 cells. I'm trying to do conditional formatting based on these to cells, and the evidence is showing that even when I type a value into either I21 or I22, they are taking on a value of zero. I have conditional formatting stating that if I21>0, then do one thing. And in a separate cell, I have =I22>0, then do another thing. Neither works, and even using =I22<>0, then do formatting, and it doesn't work, telling me that the assumed value is always zero. Any ideas of why, or how to work around this?

Please Login or Register  to view this content.

[Bob Phillips]

I reduced the code down to

Please Login or Register  to view this content.

but I am not clear what you are trying to do, this code locks all cells.

[jman0707]

The problem I was having is that with the code I'm using, if one of the cells had a positive number in it, conditional formatting still thought that it had a zero value. In conditional formatting I'd put =I22>0 and put the formatting I want, and no matter if it held a zero value or a number, it wouldn't format. So my thoughts were that it had to do with the macro controlling the cells and not the cells itself. Conditional formatting works for the rest of the worksheet.

What I need from the code (which works now) is for them both to be unlocked. If either takes a value >0, the other locks, but the cell > 0 remains unlocked. The locked cell won't unlock until a value of 0 is entered into the unlocked one with the positive value. Then they are both unlocked again. I was just wondering if anything in my code was indicative of screwing up conditional formatting. Any thoughts?

[jman0707]

The formatting works on I22 and I21, they format based on each other, but I can't get other cells in the worksheet to format based on their values. I'm clicking on another cell, typing in =$I$22>0 and filling out the formatting info, but it doesn't work. I've even tried going to the rule in I21 and I22 and applying them to other cells, and that doesn't work either. I have other cells in the sheet formatting based on other cells besides themselves, so i don't know why it's not working.......

[jman0707]

One of the cells started to work, but the other didn't. I have no clue what's messing it up, it's probably either the sheet protection or macros. But anyway, I opted to use a formula in the cell instead of conditional formatting. So I put =if(I21>0,"","Text") for the text I wanted. I had previously just tried to use conditional formatting to change the font color to the same as the background to make it disappear. So I still don't know why that doesn't work.......