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 ....