Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
58
Views
Topic starter
Hi,
Kindly give the solution for the following condition, as per details mentioned in the attached excel file.
Sr No. Condition
1 If D4:G4<today()
2 If I4<=H4 and < Today()
3 If D4:G4<today()+7 Days
4 If I4=H4
5 If D4:G4 cell contains "NA"
6 If D4:G4 cell contains "-"
Posted : 14/05/2019 3:18 am
Hi Nilesh,
It looks like you've already set up most of the rules. I noticed the first rule had a % sign after the second cell reference in the formula, which probably isn't meant to be there.
The only rule you have left to set up is NA and -. I'm not sure what you're asking us to do, as it looks like you can handle this yourself.
Mynda
Posted : 15/05/2019 7:50 am
