Microsoft Office Forums Conditional Formatting This or that

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-10-2019, 09:51 AM
lgsikaffy lgsikaffy is offline Conditional Formatting This or that Windows 10 Conditional Formatting This or that Office 2013
Novice
Conditional Formatting This or that
 
Join Date: Dec 2018
Posts: 6
lgsikaffy is on a distinguished road
Exclamation 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!
Reply With Quote
  #2  
Old 07-10-2019, 12:00 PM
Alansidman's Avatar
Alansidman Alansidman is offline Conditional Formatting This or that Windows 10 Conditional Formatting This or that Office 2019
Advanced Beginner
 
Join Date: Apr 2019
Location: Steamboat Springs
Posts: 30
Alansidman is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 07-11-2019, 05:34 AM
lgsikaffy lgsikaffy is offline Conditional Formatting This or that Windows 10 Conditional Formatting This or that Office 2013
Novice
Conditional Formatting This or that
 
Join Date: Dec 2018
Posts: 6
lgsikaffy is on a distinguished road
Default

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!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting This or that Conditional formatting derohanes Excel 1 02-20-2018 09:37 AM
Conditional Formatting This or that Conditional formatting dayperson Excel 1 02-23-2016 09:07 AM
Conditional Formatting This or that Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
Conditional Formatting This or that Conditional Formatting. Laurie B. Excel 6 04-09-2012 05:01 PM
Conditional Formatting This or that Conditional Formatting namedujour Excel 3 08-25-2011 01:46 PM


All times are GMT -7. The time now is 12:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft