If you want to highlight cells on the same row based on the max value in
column A:

Let's assume the entire range of data is A1:D10

Select the entire range starting from cell A1. A1 will be the active cell.
The active cell is the cell in the selected range that *is not* shaded.

Goto FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:

=$A1=MAX($A$1:$A$10)

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"Norfolk Bill" wrote in message
...
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