arraysif-statementgoogle-sheetsmatchconditional-formatting
Conditional Formatting applied to column based on changing custom formula not working
I am decent with excel/google sheets but haven't had any formal education with it so everything I know I have learned from the internet. With that said.
I am working on a spreadsheet that already has multiple conditional formatting rules across the entire spreadsheet. They all are working as I want except for this one I have applied:
In Column C, I want the cell to highlight if column L is greater than column K. Here is the formula example I am currently using: Apply to C65, custom formula L65>K65
The cells aren't highlighting as they should. If it makes a difference this is with Google sheets.
Solution
the CF rule should look like this:
