Conditional Formatting Problem
 

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

Conditional Formatting Problem
 

Hi,

Try this:

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

HTH
Jean-Guy

"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

Conditional Formatting Problem
 

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,$A2100000))
Format: Blue and Bold Italic

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

Condition 3:
Formula: =MOD(ROW(),2)=0
Format: Blue
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Steve Wright" wrote in message news:1170370557.550463@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

Conditional Formatting Problem
 

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,A1100000))
Pattern: light blue
Font: bold italic

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

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

Biff

"pinmaster" wrote in message
...
Hi,

Try this:

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

HTH
Jean-Guy

"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

Conditional Formatting Problem
 

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

Conditional Formatting Problem
 

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

Biff

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