Log In
Register
Home
Multiple Conditional Formatting
Nilesh Kandalgaonkar
New Member
Members
Forum Posts: 1
Member Since:
May 13, 2019
May 13, 2019
Offline1
May 13, 2019 - 5:18 pm
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 "-"
Mynda Treacy
Admin
Forum Posts: 4769
Member Since:
July 16, 2010
July 16, 2010
Offline2
May 14, 2019 - 9:50 pm
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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Alan Sidman, Velouria
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 919
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 339
David_Ng: 306
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Michael Denton
Nick Pascal
David Webb
Johannes Bruentrup
John Jay
Larry Silverman
David Rousseau
Melinda Heidemann
Jose Fuentes
Abigail Hernandez
Forum Stats:
Groups: 3
Forums: 25
Topics: 7072
Posts: 30993
Member Stats:
Guest Posters: 49
Members: 34469
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —