- Jul 24, 2018
- Office Version
Good morning I have a strange request. I am working on calculating if an employee missed any time during the previous month. I have it written to a table and am using Conditional Formatting to highlight any value greater than 0 (That would indicate lost time). If in any month prior to the current month the employee has a 0 I need to add 3 (example....If on 3/1/19 an employee has two 0 for Jan and Feb then they would have 6 in accrued hours). If the cell is greater than 0 then they get 0. I am stuck on the IF portion of the formula because I do not know how to get it to only calculate the 0 for previous months. Any help would be appreciated...