Help needed with Conditional formatting

I have a spread sheet containing 10 major columns and 240 rows. The data
shown is meteorological values relating to wind speed, wind direction, max.
Temperature, min temp, barometric pressure and others..for one days recording

I need to show in a column the max cell value and highlight this cell
together with an adjacent cell on the same row. I have been given a formula
as, Select Column A then =A1= MAX(A:A) then to format to a colour.
Can you advise me on the new formula for appling this to different rows ??
Also, can I save this applied formula so that I can paste it to another
spread sheet section for each of the following days of data ?? I have MS
2003 running
Bill