conditional formatting issue
 

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

conditional formatting issue
 

With your numbers in b1:b9 and your average in b10, select b1:b9 and
Format/Conditional Format, change to formula is and try this formula:
=B1<$B$10
then change the format to what you want to see.
--
Kevin Vaughn


"QUESTION-MARK" wrote:

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

conditional formatting issue
 

Yes!! That worked. Thank you for your time.

Mark

conditional formatting issue
 

You are welcome. Glad it helped.
--
Kevin Vaughn


"QUESTION-MARK" wrote:

Yes!! That worked. Thank you for your time.

Mark