Describe the bug
Conditional Formatting with custom formulas not formatting correct cells. the same formula works as a value for a cell, but not in conditional formatting.
To Reproduce
Steps to reproduce the behavior:
Go to Conditional Formatting
Click on Create Custom Rule with formula
use range of all cells
=INDIRECT("F" & ROW())="dungeon"
rows with "dungeon" in the F column are not highlighted, even though they are in the excel webapp
test data
blue troll
1
frost
yeti
1
frost
green slime
1
dungeon
skeleton
1
dungeon
goblin
1
dungeon
blue slime
1
dungeon
Expected behavior
all rows with "dungeon" in in column F should be highlighted
Screenshots
If applicable, add screenshots to help explain your problem.
Device (please complete the following information):
OS: Ubuntu
Version 22.04
Obsidian (please complete the following information):
Version 1.7.4
Additional context
Add any other context about the problem here.
Describe the bug Conditional Formatting with custom formulas not formatting correct cells. the same formula works as a value for a cell, but not in conditional formatting.
To Reproduce Steps to reproduce the behavior:
test data
Expected behavior all rows with "dungeon" in in column F should be highlighted
Screenshots If applicable, add screenshots to help explain your problem.
Device (please complete the following information):
Obsidian (please complete the following information):
Additional context Add any other context about the problem here.