Oh I wish I was smarter. I was tasked with making my workbook actually work - and be smaller so I could email it out. I think VBA may be my only answer. Another genius here helped me come up with a conditional format for my worksheet. Here is the scenario. You can also look at the attached.
I have a table with columns from A - Z. In column A3 is Date In. B3 is Date Out. C3 is =networkdays(). Normal data, (text, dates, general and accounting take up the rest of the columns).
The Condition: When a value is entered anywhere on a line (other than B3) the whole line will turn our favorite bright yellow). When a date is entered into B3, the whole line is unhighlighted, regardless of what else is entered. Keep in mind the formula for network days may be a challenge?
While I'm asking for the moon, the sheet name should appear in A2.
This would need to be in up to 5 worksheets, but could be less.
Is anyone up to the challenge of making my day any better? In advance, thank you so very much. I am very grateful.
Bookmarks