Cond Formatting: Green Amber Red

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following three expressions for conditional formatting but can
only get the Green and Red to work.

(IsNull([AAA-095]) And ((Now())<[Bn S:]-1)) Or (([AAA-095])<=([Bn S:]))
Then Green
(IsNull([AAA-095]) And ((Now())+1=[Bn S:]))
Then Amber
((IsNull([AAA-095]) And ((Now())>=[Bn S:])) Or ([AAA-095])>([Bn S:]))
Then Red

Amber won't work. I've also tried
(IsNull([AAA-095]) And ((Now())=[Bn S:]-1))
 
What type of data does the [Bn S:] field contain? Now returns a date and
time value, meaning that it shows current date and current time. If [Bn S:]
contains just a date, use Date() instead of Now().
 
Sir,

Perfect, Thank you so very much!!!!!!

Ken Snell (MVP) said:
What type of data does the [Bn S:] field contain? Now returns a date and
time value, meaning that it shows current date and current time. If [Bn S:]
contains just a date, use Date() instead of Now().

--

Ken Snell
<MS ACCESS MVP>

franklinbukoski said:
I have the following three expressions for conditional formatting but can
only get the Green and Red to work.

(IsNull([AAA-095]) And ((Now())<[Bn S:]-1)) Or (([AAA-095])<=([Bn S:]))
Then Green
(IsNull([AAA-095]) And ((Now())+1=[Bn S:]))
Then Amber
((IsNull([AAA-095]) And ((Now())>=[Bn S:])) Or ([AAA-095])>([Bn S:]))
Then Red

Amber won't work. I've also tried
(IsNull([AAA-095]) And ((Now())=[Bn S:]-1))
Click to expand...
Click to expand...
 
Back
Top