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
|