Highlight Rule Error?
Why is this 40000.00 number being highlighted in a tan colour? The rule is explicit:
Equal to cell E3 which is 0.00 and not 40000.00? It's matching the decimals?
[Edited by Moderator]
MacBook Pro 16″
Why is this 40000.00 number being highlighted in a tan colour? The rule is explicit:
Equal to cell E3 which is 0.00 and not 40000.00? It's matching the decimals?
[Edited by Moderator]
MacBook Pro 16″
Ahh, yes well sussed, there were 10 highlight rules and one did indeed reference the number 40000, cheers, 👌
Did the default format for that cell somehow get set to that color?
Is there more than one rule for the cell (screenshot was cropped, I can't tell from it)?
Highlight Rule Error?