buttonnose
New Member
- Joined
- Dec 9, 2005
- Messages
- 5
hi everyone,
i'm very new to this, hope u guys would be able to help.
i need to use conditional format for this i'm sure but do not know how & where to start.
i'm have this cell that has 3 different conditions. I know how to use different colors for different scenarios but my problem now is my criteria / condition involves date. to be precise, the SYSTEM DATE.
ok, say for example today's date is 9 Dec right? it is 20 days away from my deadline (29th) so it should be blue in color. so on and so fore.
how do i then write the method / conditional statement? pls advice. i hope i've explain it well.
i'm very new to this, hope u guys would be able to help.
i need to use conditional format for this i'm sure but do not know how & where to start.
i'm have this cell that has 3 different conditions. I know how to use different colors for different scenarios but my problem now is my criteria / condition involves date. to be precise, the SYSTEM DATE.
ok, say for example today's date is 9 Dec right? it is 20 days away from my deadline (29th) so it should be blue in color. so on and so fore.
how do i then write the method / conditional statement? pls advice. i hope i've explain it well.