Quote:
Originally Posted by ArviLaanemets
Conditional formatting doesn't recognize Tables, and it doesn't work with named ranges either.
|
You might want to check the part about CF not working with named ranges.
I defined a block of 3 numbers and assigned the named range MyNumbers to it. In those cells I typed in 1, 1, and 1.
As an example, I used in CF >> =SUM(MyNumbers)=3
Works okay for me.