Conditional Formatting?

[range-ball]

I am trying to figure out how to format a cell depending on its value compared to other cell values. For example:

A1 10
A2 11
A3 12
A4 13

What I want to do is to have the four numbers (10,11,12 and 13) in the four cells (A1,A2,A3 and A4) compared and to have the conditional formatting (or some other means) highlight the largest number in red. So, in this case I would like to set up the formatting such that the number 14 in cell A4 shows up in red. Does anyone know how to do this?

[VBA Noob]

Try

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

http://www.contextures.com/xlCondFormat01.html

VBA Noob