JohnZ1156
Board Regular
- Joined
- Apr 10, 2021
- Messages
- 160
- Office Version
- 2021
- Platform
- Windows
I have an excel table of data with the starting row in row 10. I would like to setup a dynamic conditional format to show the Top 1 for a specific column in the table, (not the whole column D) I can't use "=C12=max(Sheet2!D:D)", because it includes values in Column D Rows 1-9, I tried "=C12=max(table1[Amount])", but that won't work either. Ideas!