Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i tried this below expression.
=if(Date(Date_1)>Today(),If((NetWorkDays(Date(Date_1),Today()))<10,'0-10',If((NetWorkDays(Date(Date_1),Today()))<20,'10-20','+20')),
If(((NetWorkDays(Date(Date_1),Today()-1))<10)*-1,'0-(10)',
If(((NetWorkDays(Date(Date_1),Today()-1))<20)*-1,'(10)-(20)','(20)+')))
we required + Values should be Green() and - Values be in Red.
HI,
You can do thing. use a create a master item and divide your demensions into two category +ve and -ve then you you easily change the color of dimension ...
whatever will comes into +ve ,it will show into one color and rest of the things will be in the other color
try this and tell me
i tired no results..