MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
How do I write formulas rules that are based upon multiple columns and/or rows in a table (not a usual/normal range)?
Following is a simple example (my actual data has >1,000 rows and many columns) and my actual conditions are more complex.
When I insert/delete/reorder new rows/columns I do not want to update the conditional formatting formula so I'm using named ranges for the columns (i.e. =Table1[[#All],[Date]], etc. )
I need to highlight the value in Amt2 if it is not the same as Amt1. If Amt1 is empty or blank don't highlight Amt2.