Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
Conditional formatting problem | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) | |||
Conditional Formatting Problem | Excel Discussion (Misc queries) |