Conditional formatting with Table range only

[JohnZ1156]

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!

 

[dreid1011]

Can you not define a large enough range to account for most situations, if not all?

=C12=max(Sheet2!D10:D1000)

 

[Fluff]

How about

=C12=max(indirect("table1[Amount]"))