Forum Discussion

Maureen Polhy Gamarra Ortega

Copper Contributor

Mar 23, 2018

Conditional Formatting

Hello, How do i create a conditional formatting based on the table below for next re-qualification? Thanks, Maureen

Formulas & Functions

tips and tricks

pranav trikha

Brass Contributor

Jul 19, 2018

Greetings!

Add dates (I,e.) number of days for next qualification, go to conditional formatting tab, choose Highlight Cell > Greater Than option > enter the end date (i.e. the date for next qualification, test), choose appropriate formatting. Repeat for each cell.

Hope it helps,

Thanks,