I have a sheet in which I made four conditional formats and four custom number formats.
The conditional formats are each applied to cell C90. I used New Rule > Use a formula to determine which cells to format.
The Equation for the first is:
The Equation for the second is:
And so on.
The custom number format corresponding to the first one is:
The custom number format corresponding to the second one is:
And so on.
When I try them out, they don't work the first time you try. When I change the value of E91 from 3 to
4, C90 still has "(#3)".
If I again put 4 into it and hit enter, C90 will change to "(#4)".
If I enter 5 into C90 after having 4 in there, it will then change to "(#4)"
But if I go straight from 3 to 5, it will stay at "(#3)"
I tried assigning different fills to go along with each custom number format. The fills change when they are supposed to.
I also tried assigning pre-defined number formats to the cells and they are also not working correctly
There must be some sort of problem with number formats not updating right away.