Forum Discussion
Solved
Conditional Formatting Formula Error
Hello all, I've tried using the formula below within conditional formatting, but it returns "There's a problem with this formula" (If screenshots would help, I can provide those). =...
Conditional Formatting does not accept structured table references in a formula. You'll have to use the corresponding cell addresses.
Select the range of cells in a column where some of the cells contain errors.
Click the Home tab in the Ribbon and select Conditional Formatting in the Styles group.
Select New Rule from the drop-down menu.
Click Use a formula to determine which cells to format.
Regards,
Will
Click the Home tab in the Ribbon and select Conditional Formatting in the Styles group.
Select New Rule from the drop-down menu.
Click Use a formula to determine which cells to format.
Regards,
Will