Affects Version/s: 5.5.0
Fix Version/s: 5.6.0
Security Level: Jimmy
Steps to Reproduce
1. import the file
2. select "source" sheet
3. modify A2, A3 to the same value
4. check the background color at conditional formatting!B3
- Keikai displays the expected background initially but doesn't update after the referenced cell value change.
- B3 contains conditional formatting that references cells with named ranges. Referencing a named range of another sheet is the only way to make conditional formatting reference to another sheet.
modify B3 value and keikai will update the background-color