CrazyBritGuy
New Member
- Joined
- Dec 10, 2019
- Messages
- 13
- Office Version
- 2016
- Platform
- Windows
How do I write formulas rules that are based upon multiple columns and/or rows in a table?
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 Amt1.
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 Amt1.