Conditional Formating Problem

[Steve Wright]

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

 

[Joerg]

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