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 22 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014 - Aug 4, 2014 at 03:40 PM


From the image posted I want to be able to highlight the row when the done column is empty and is not today's date.

1 reply

Osama_bb11 Posts 22 Registration date Sunday May 25, 2014 Status Member Last seen September 25, 2014
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
0