May 05 2022 10:09 AM
I'm trying to use a formula to conditionally format and I keep getting the error message "There's a problem with this formula." I want to highlight projects in column A if they are less than 7 days old. I created a formula (LAMDA) that correctly calculates the number of days on the project (column B) and I used the same formula <7 to generate TRUE/FALSE results (column C).
I can conditionally format columns B and C and I can conditionally format column A if I refer to either column B or C. I cannot use either the B column or C column formula in a conditional format directly on $A31.
I've verified the following:
* the Formula checker found no errors on the worksheet;
* my references are correct when I've pasted the formulas into Conditional Formatting formula bar ($A31 is the active cell and the formula is the same as the formula on the worksheet);
* Abiola David noted an apparent bug in using LAMDA calculations in conditional formatting in his YouTube channel but this doesn't seem to be related to my issue. I've created an XLOOKUP formula that gets the same results and get the same error message.
May 05 2022 12:06 PM
Which exactly formula do you try to use?
May 05 2022 05:27 PM
May 06 2022 08:03 AM
We can't use structured reference and arrays in conditional formatting. Try =$C31 instead or use direct references.