Thanks to both for the help. However, I am not getting it to work. It takes
all shading out and changes the font on rows without shading. Same as before.
I did it twice and checked each time for a grammer errors.

I am conditionally formating columns.

Any ideas what I might be doing wrong?




"Bernie Deitrick" wrote:

Ronbo,

You need 3 CF's. The first should be

=AND(MOD(ROW(),2)=0,A1<0)

formatted red font, shaded background.

Then your other two as before.

HTH,
Bernie
MS Excel MVP


"Ronbo" wrote in message
...
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.