More than one rule in excle
Closed
rassel724
Posts
1
Registration date
Monday August 4, 2014
Status
Member
Last seen
August 4, 2014
-
Aug 4, 2014 at 11:54 AM
Osama_bb11 Posts 21 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014 - Aug 4, 2014 at 03:40 PM
Osama_bb11 Posts 21 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014 - Aug 4, 2014 at 03:40 PM
Related:
- More than one rule in excle
- Outlook rule not working - Guide
1 response
Osama_bb11
Posts
21
Registration date
Sunday May 25, 2014
Status
Member
Last seen
September 25, 2014
Aug 4, 2014 at 03:40 PM
Aug 4, 2014 at 03:40 PM
Hi Resel,
you can't say (.... is empty and is not today's date....) the value of date for evaluation will make the column non empty so ....you need two columns :
- column (D) to show the (done) status empty or not
- column (B) to show the date
the conditional format should be like this
=AND($B2=TODAY(), $D2="")
hopefully this will works
Eng. Osama
UAE-Abu Dhabi
you can't say (.... is empty and is not today's date....) the value of date for evaluation will make the column non empty so ....you need two columns :
- column (D) to show the (done) status empty or not
- column (B) to show the date
the conditional format should be like this
=AND($B2=TODAY(), $D2="")
hopefully this will works
Eng. Osama
UAE-Abu Dhabi
