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

You need 2 formulas. Example assumes that you format cell A1 (and then copy
as needed) and that the value to be formatted bold italics is greater 5 and
less than 10:

Condition1:
=AND(MOD(ROW(),2)=0,A1>5,A1<10)
Format: light blue, font Bold Italics

Condition2:
=MOD(ROW(),2)=0
Format: light blue, font normal

Cheers,

Joerg


"Steve Wright" <(E-Mail Removed)> wrote in message
news:1165199270.899572@muldoon...
> 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
>
>