-
Bug
-
Resolution: Fixed
-
Normal
-
5.5.0
-
None
-
Security Level: Jimmy
-
None
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
Current Result
it's red
Expected Result
white
Debug Information
- 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.
Workaround
modify B3 value and keikai will update the background-color