Conditional formatting a row based on active cell without using VBA.

%3CLINGO-SUB%20id%3D%22lingo-sub-2385098%22%20slang%3D%22en-US%22%3EConditional%20formatting%20a%20row%20based%20on%20active%20cell%20without%20using%20VBA.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2385098%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20highlight%20the%20selected%20row%20using%20conditional%20formatting.%20It%20works%20in%20another%20spreadsheet%20I%20have%20using%20the%20formula%20%3DROW()%3DCELL(%22row%22)%20but%20that%20spreadsheet%20is%20macro%20enabled%20whereas%20this%20new%20spreadsheet%20is%20not%20due%20to%20its%20connection%20to%20Power%20Automate.%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20my%20question%20is%2C%20is%20there%20a%20way%20to%20make%20it%20work%20without%20having%20to%20press%20F9%20to%20recalculate%20or%20using%20VBA%20after%20selecting%20a%20new%20cell%3F%20The%20only%20way%20it%20works%20is%20if%20I%20click%20into%20the%20cell%20and%20then%20tab%20out%20or%20press%20enter.%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2385098%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

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.

0 Replies