Hello
Caclulation is set to automatic.
Cell B6 formula is =B19.
B118 =SUMPRODUCT(--(RIGHT($A119:$A190,5)="TOTAL"),--B119:B190)
Conditional formating for B6 is =B6<B118
If I make a change in B119:B190 that changes B118 to where it is no longer =
to B19 then CF does not update until I select B6 then hit F2 to enter edit
mode (make no changes) then hit enter. Manual recalc (F9) does not update
the CF.
Any ideas?