-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
permit
-
S
Conditional Formating Required for changing Dates based on 2 different cell dates
Hi, I creating a permit register. End Goal : Have the text in both Cells in "Start Date" and "Finish Date" have the same colour to determine if the Permit is 'Expired', 'Current' or set in the 'future' Column H (Permit Start Date) and Column I (Permit Finish Date). Permit dates do not have...- salsy
- Thread
- conditional cells date date formulas formula and dates permit
- Replies: 1
- Forum: Excel Questions
-
J
Help! Complex Question - Maybe VLookUp or If/Max Commands??
Hi! I have been trying (for the past several hours) to find a solution to an issue that I have been having to no avail. Here is my issue: On one sheet I have a list, let's say construction projects. Each column contains pieces of other information on each project that is formatted so I...- jet05c
- Thread
- formula max permit project vlookup
- Replies: 4
- Forum: Excel Questions
-
R
MATCH, INDEX or LOOKUP
Hi all, I'm hoping for some help with a query I have. I'm currently drafting a quick spreadsheet, this will consist of 2 tabs. The first tab will list such information as "permit holders name", "date" as well as a "permit number"; the person can appear on this tab on numerous occassions...- RankinC
- Thread
- column holders permit person tab
- Replies: 6
- Forum: Excel Questions
