when encountered Zero/Blank CF issues ...
 

New to Excel Programming ..

Question is how to achieve the following could be very simple but dang not
able to figure :
this is applied to whole column ,testing on a cell currently
AI19=0.2 Blue
AI19<-0.2 Green
=OR/AND(AI19<0.2,AI19-0.2,NOT(ISZERO(AI19))) RED...(this doesn't work for
some reason)
= when ZERO or BLANK ? WHITE (tricky part not able to figure)..

Don't know much of Macros ....

when encountered Zero/Blank CF issues ...
 

Set the default to white, that is not C F.

The non-working formula should be

=AND(AI19-0.2,AI19<0.2,AI19<0)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Raj" wrote in message
...
New to Excel Programming ..

Question is how to achieve the following could be very simple but dang not
able to figure :
this is applied to whole column ,testing on a cell currently
AI19=0.2 Blue
AI19<-0.2 Green
=OR/AND(AI19<0.2,AI19-0.2,NOT(ISZERO(AI19))) RED...(this doesn't work
for
some reason)
= when ZERO or BLANK ? WHITE (tricky part not able to figure)..

Don't know much of Macros ....

when encountered Zero/Blank CF issues ...
 

=if(And(abs(AI19)<0.02,AI19<0,AI19<""),"Red","Wh ite")

--
Regards,
Tom Ogilvy



"Raj" wrote:

New to Excel Programming ..

Question is how to achieve the following could be very simple but dang not
able to figure :
this is applied to whole column ,testing on a cell currently
AI19=0.2 Blue
AI19<-0.2 Green
=OR/AND(AI19<0.2,AI19-0.2,NOT(ISZERO(AI19))) RED...(this doesn't work for
some reason)
= when ZERO or BLANK ? WHITE (tricky part not able to figure)..

Don't know much of Macros ....

when encountered Zero/Blank CF issues ...
 

Didn't see the CF in the subject

use formula is in all cases

first condition

=And(abs($AI$19)<=0.2,$AI$19<0,$AI$18<"")
format for Red

2nd condition
=$AI$190.2
format for blue

3rd condition
=$AI$19<-0.2
format for green

--
Regards,
Tom Ogilvy

"Raj" wrote:

New to Excel Programming ..

Question is how to achieve the following could be very simple but dang not
able to figure :
this is applied to whole column ,testing on a cell currently
AI19=0.2 Blue
AI19<-0.2 Green
=OR/AND(AI19<0.2,AI19-0.2,NOT(ISZERO(AI19))) RED...(this doesn't work for
some reason)
= when ZERO or BLANK ? WHITE (tricky part not able to figure)..

Don't know much of Macros ....

when encountered Zero/Blank CF issues ...
 

slight adjustment

first condition

=And(abs($AI$19)<0.2,$AI$19<0)
format for Red

2nd condition
=$AI$19=0.2
format for blue

3rd condition
=$AI$19<=-0.2
format for green


--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote:

Didn't see the CF in the subject

use formula is in all cases

first condition

=And(abs($AI$19)<=0.2,$AI$19<0,$AI$18<"")
format for Red

2nd condition
=$AI$190.2
format for blue

3rd condition
=$AI$19<-0.2
format for green

--
Regards,
Tom Ogilvy

"Raj" wrote:

New to Excel Programming ..

Question is how to achieve the following could be very simple but dang not
able to figure :
this is applied to whole column ,testing on a cell currently
AI19=0.2 Blue
AI19<-0.2 Green
=OR/AND(AI19<0.2,AI19-0.2,NOT(ISZERO(AI19))) RED...(this doesn't work for
some reason)
= when ZERO or BLANK ? WHITE (tricky part not able to figure)..

Don't know much of Macros ....

when encountered Zero/Blank CF issues ...
 

How to Set Default color in CF or spreadsheet ? BTW your suggestions have
helped figure solution . Thx Tom and Bob .
great help indeed,
Raj



"Tom Ogilvy" wrote:

slight adjustment

first condition

=And(abs($AI$19)<0.2,$AI$19<0)
format for Red

2nd condition
=$AI$19=0.2
format for blue

3rd condition
=$AI$19<=-0.2
format for green


--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote:

Didn't see the CF in the subject

use formula is in all cases

first condition

=And(abs($AI$19)<=0.2,$AI$19<0,$AI$18<"")
format for Red

2nd condition
=$AI$190.2
format for blue

3rd condition
=$AI$19<-0.2
format for green

--
Regards,
Tom Ogilvy

"Raj" wrote:

New to Excel Programming ..

Question is how to achieve the following could be very simple but dang not
able to figure :
this is applied to whole column ,testing on a cell currently
AI19=0.2 Blue
AI19<-0.2 Green
=OR/AND(AI19<0.2,AI19-0.2,NOT(ISZERO(AI19))) RED...(this doesn't work for
some reason)
= when ZERO or BLANK ? WHITE (tricky part not able to figure)..

Don't know much of Macros ....

when encountered Zero/Blank CF issues ...
 

The default color is the same as for all other cells or if you manually
change the cell color, then the color you changed it to.

If a CF condition is not applied, it remains the color that it has been
formatted to normally.

--
Regards,
Tom Ogilvy



"Raj" wrote:

How to Set Default color in CF or spreadsheet ? BTW your suggestions have
helped figure solution . Thx Tom and Bob .
great help indeed,
Raj



"Tom Ogilvy" wrote:

slight adjustment

first condition

=And(abs($AI$19)<0.2,$AI$19<0)
format for Red

2nd condition
=$AI$19=0.2
format for blue

3rd condition
=$AI$19<=-0.2
format for green


--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote:

Didn't see the CF in the subject

use formula is in all cases

first condition

=And(abs($AI$19)<=0.2,$AI$19<0,$AI$18<"")
format for Red

2nd condition
=$AI$190.2
format for blue

3rd condition
=$AI$19<-0.2
format for green

--
Regards,
Tom Ogilvy

"Raj" wrote:

New to Excel Programming ..

Question is how to achieve the following could be very simple but dang not
able to figure :
this is applied to whole column ,testing on a cell currently
AI19=0.2 Blue
AI19<-0.2 Green
=OR/AND(AI19<0.2,AI19-0.2,NOT(ISZERO(AI19))) RED...(this doesn't work for
some reason)
= when ZERO or BLANK ? WHITE (tricky part not able to figure)..

Don't know much of Macros ....