software

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,
MarkWith 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:
=B1lt;$B$10
then change the format to what you want to see.
--
Kevin Vaughnquot;QUESTION-MARKquot; wrote:

gt; I am using Excel 2003 and have a table where the bottom number shows an
gt; average of the rows above. I want to conditionally format the numbers
gt; that are below the average as it changes.
gt;
gt; Is there something that I can put in the cells containing the values
gt; that I am averaging which will conditional format them if they are
gt; lower than the average?
gt;
gt; Thank you,
gt; Mark
gt;
gt;

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

MarkYou are welcome. Glad it helped.
--
Kevin Vaughnquot;QUESTION-MARKquot; wrote:

gt; Yes!! That worked. Thank you for your time.
gt;
gt; Mark
gt;
gt;