Condtion 1:
=AND(MOD(ROW(),2)=0,ABS($A1)100000)
format light blue color and Bold Italics

Condition 2:
=MOD(ROW(),2)=0
format light blue color


"Steve Wright" wrote:

I have a conditional format that turns every cell on an even row light blue
using a conditional format of Formula is: "=MOD(ROW(),2)=0".

My problem is that I want to retain the light blue colour and format the
font to Bold Italics where the value is less than -100000 and greater than
100000.

Does any one have any ideas?

Steve