Hi all,
I am trying to highlight the selected row using conditional formatting. It works in another spreadsheet I have using the formula =ROW()=CELL("row") but that spreadsheet is macro enabled whereas this new spreadsheet is not due to its connection to Power Automate.
So my question is, is there a way to make it work without having to press F9 to recalculate or using VBA after selecting a new cell? The only way it works is if I click into the cell and then tab out or press enter.
Thanks in advance.
