What conditional formatting formula(s) do I use to accomplish this? I can't seem to get Excel to recognize each cell as it's own date - and most help I've found online is calculating based off of today's date, which is not the case here. Any blank cell should remain blank with no formatting.Įach cell is completely independent because even for the same employee they could have different training dates for different pieces of equipment. So, I would like each cell (with a date in it) to turn yellow when 2 years have passed, and red when 3 years have passed (and it is expired). Not all employees are trained on all equipment, so some cells are blank. In the formula box, enter AND (B2>G2,C2>G3) Click the Format button and select the Formatting option, such as Fill > Red color > OK. Click the option Use a Formula to Determine Which Cells to Format. Of equipment, their date of certification is put in the cell using the format "mm/dd/yyyy". On the Home tab, click Conditional Formatting and then click New Rule. Ive set rules for both of the cells that. This pulls up the Conditional Formatting Rules Manager.
From the Home tab, you can select Conditional Formatting and choose Manage Rules. If the employee has been trained on a piece Now that we have icons you can see through, we are going to set them on specific cells that we can reference in our conditional formatting. This spreadsheet has about 200 employees (rows), and 5 different types of equipment to be trained on (columns). Now, in the Format values where formula is true enter below formula. After that, go to Home Tab Styles Conditional Formatting New Rule Use a formula to determine which cell to format. I have a spreadsheet that tracks when an employee was trained on a certain piece of equipment. First of all, select the range where you want to apply conditional formatting.
0 kommentar(er)
