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:
- Which two sentences correctly describe the use of formulas in performing calculations in spreadsheets? all formulas written for a spreadsheet must follow certain rules, which we call syntax. when creating a formula in a spreadsheet, always start with an if statement. basic statements include numeric values and operators. if there are multiple operators, then the order of precedence starts with exponents. parentheses are used to isolate certain parts of the expression from the other parts. operations in parentheses are completed after the rest of the formula is evaluated.
- Spreadsheet formula - Guide
- Square parentheses mac - Guide
- Formula to calculate vat in excel - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - 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
