Conditional Formatting Dynamic Column Based on Cell Value

[Charles651]

I'm trying to find a way to use conditional formatting to highlight a column based on a value in the cell on the column's top row. The length of the row changes from day to day so the value can appear in different columns but will appear only once in that row. For instance, I have a row beginning at A6 and ending at K6 for today's spreadsheet, but tomorrow the row values could stop at J6 or L6. The values in the row are, from A6 to K6:

A B C D E F G H I J K
1
2
3
4
5
6 -5 -4 -3 -2 -1 0 1 2 3 4 5

I want the formula to look for the cell ("F6" in this case) containing "0" and then highlight the cell and all those below it in the same column. I'd appreciate any guidance on how to do this, if it can be done.

 

[Charles651]

I apologize for this but my table spacing in the example did not format properly. The numbers down the left represent row numbers. Cell A6 is -5, Cell B6 is -4, and so on.