TresRing
New Member
- Joined
- Sep 12, 2017
- Messages
- 16
Hi, I'm sure this will be an easy one for you all, but I can't find an answer online and I can't figure out how to make it work. I've tried various conditional formatting rules, which I'd prefer if possible, but none of them works when conditions are met. So I resorted to macros and have spent 2 days manipulating different codes with no joy. Can you please help me?
The scenario is, if Person1-Person5, and Person7 are traveling, their cost is Number1. If Person6 is traveling, their cost is Number 2. If any person1-7 is NOT traveling, their cost is 0 or blank.
This is the formula I need to work out for each sheet an entire 13-sheet workbook:
If you can help me get this to work either with CF or macros, I would be thankful to the moon and back.
/TR
The scenario is, if Person1-Person5, and Person7 are traveling, their cost is Number1. If Person6 is traveling, their cost is Number 2. If any person1-7 is NOT traveling, their cost is 0 or blank.
This is the formula I need to work out for each sheet an entire 13-sheet workbook:
If H:H = Yes, Then J:J = Number1 (any yes on that column gets a number assigned to the adjacent)
Else If H:H = Yes, AND A:A = Name, Then J:J = Number2 (this is the exception)
Or If H:H = No, Then J:J = Blank
Else If H:H = Yes, AND A:A = Name, Then J:J = Number2 (this is the exception)
Or If H:H = No, Then J:J = Blank
If you can help me get this to work either with CF or macros, I would be thankful to the moon and back.
/TR