Conditional formatting in ODBC query

[j3andc]

I have a ODBC query where I want to highlight certain rows when a cell contains the number 1. This last cell is outside of the ODBC query.

So far I cannot get the whole row to highlight only one cell. Any help would be greatly appreciated.

Thanks

Jim S.

 

[6StringJazzer]

What is the cell you want to check for 1? What columns contain your data?

In general you want to format the entire set of data using the rule

=$B1=1

where you want to test each row to see if there is a 1 in column B. I am guessing you are close but missing the $.

 

[j3andc]

I just discovered that it is the difference between =$B$1 = 1 and =$B1 = 1. The second one worked.