Yes, you need three CFs.

CF1: =AND(A1<0,MOD(ROW(),2)=0) (shade cell and red font)
CF2: =AND(A1=0,MOD(ROW(),2)=0) (shade cell and black font)
CF3: =AND(A1<0,MOD(ROW(),2)=1) (no shade and red font)

Regards,
B.R.Ramachandran

"Ronbo" wrote:

The first conditional format is "=MOD(ROW(),2)=0". This auto shades every
other row and fixs the rows color so if I do a sort the rows will still be
shaded every other row.

The second Conditional Format is to color the font red if less than 0.
However, if a negitive number is in a row that has been shaded, the font will
not trun red, in the other rows the negatives are red.

What can I do to have both the shaded cell and red negative numbers?

As always, any help is very much appreciated.