#1
|
|||
|
|||
Conditional Formatting This or that
Hello,
I have created an attendance tracker with Excel, and I need to update the conditional formatting that highlights what kind of disciplinary action report should be given. The policy now says that if an Employee has less than 90 days with the company will be subject to disciplinary action in accordance with the table below: Points Corrective Action 5 points Verbal Warning 10 points Written Warning 15 points Termination If more than 90 days, it should be the following: Points Corrective Action 10 points Verbal Warning 15 points Written Warning 20 points Final Written Warning* 25 points Termination I have a cell that indicates the date of hire, how can I create the formatting that will highlight which disciplinary action should be given if less than 90 days or if more than 90 days? Thanks so much! |
#2
|
||||
|
||||
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data. |
#3
|
|||
|
|||
Attendance Tracking.xlsm - Google Drive
I wasn't able to upload it to this site. I started with the dates but for some reason it's showing a 90 date when the hire date is blank. Please help me Thanks! |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formatting | derohanes | Excel | 1 | 02-20-2018 09:37 AM |
Conditional formatting | dayperson | Excel | 1 | 02-23-2016 09:07 AM |
Conditional formatting that ignores other formatting rules | info_guy2 | Excel | 1 | 07-03-2014 10:07 AM |
Conditional Formatting. | Laurie B. | Excel | 6 | 04-09-2012 05:01 PM |
Conditional Formatting | namedujour | Excel | 3 | 08-25-2011 01:46 PM |