Hi EboniDimplz,

Where are the Names?
Sales for Sales #1 in A26
Sales for Sales #2 in A27
Sales for Sales #3 in A28
Sales for Sales #4 in A29
Sales for Sales #5 in A30
don't look like names but I'm guessing these are the cells to be red,
bold and italic for below average sales based on a comparison of
adjacent sales figures with the average sales figure in G26

Select A26:A30
Go FormatConditional formatting
In the Conditional Formatting dialog use the down arrow to change "Cell
Value Is" to "Formula Is"
Type this formula into the box immediately to the right of "Formula
Is"...

=B26<$G$26

Click the Format... button

On the Font tab of the Format Cells dialog click on Italic and Bold in
the Font Style: box, then click on red in the Font Color dropdown.

Click OK on the Format Cells dialog

Click OK on the Conditional Formatting dialog

That should achieve the desired effect.

Ken Johnson