Conditional Formatting 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

 

[Guest]

Hi,

Try this:

condition 1:
=AND(MOD(ROW(),2)=0,OR(A1<-100000,A1>100000))
condition 2:
=MOD(ROW(),2)=0

HTH
Jean-Guy

 

[Earl Kiosterud]

Steve,

Select your cells. Note the active (white) cell. In this case, it's row 2, and the cell
being tested is in column A.

Condition 1:
Formula: =AND(MOD(ROW(),2)=0,OR($A2<-100000,$A2>100000))
Format: Blue and Bold Italic

Condition 2:
Formula: =AND(MOD(ROW(),1)=0,OR($A2<-100000,$A2>100000))
Format: Bold Italic

Condition 3:
Formula: =MOD(ROW(),2)=0
Format: Blue

 

[T. Valko]

That misses where the MOD <>0 but the value is/or <-100000 >100000

Try this:

Condition 1
=AND(MOD(ROW(),2)=0,OR(A1<-100000,A1>100000))
Pattern: light blue
Font: bold italic

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

Condition 3
=OR(A1<-100000,A1>100000)
Font: bold italic

Biff

 

[Guest]

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

 

[T. Valko]

That misses where the MOD <>0 but the value is/or <-100000 >100000

Biff