I am using Excel 2003 and have a table where the bottom number shows an
average of the rows above. I want to conditionally format the numbers
that are below the average as it changes.

Is there something that I can put in the cells containing the values
that I am averaging which will conditional format them if they are
lower than the average?

Thank you,
Mark