My table (tblexpense) has column headers Jan - Dec. I understand that if I want to sum row in table I can use reference =sum(tblExpense[@[Jan]:[Dec]]). How can I create conditional format to highlight any cell in table row if the value exceeds a budget threshold I've set for that expense?
Is this possible or would I have to create a rule for every individual cell?
Is this possible or would I have to create a rule for every individual cell?