Forum Discussion
Select from multiple conditional format rules, based on value of another cell.
I have a spreadsheet tracking due dates for deliverables, depending on what department a deliverable is for, the acceptable time taken from order to delivery varies. On Column H, I have a formula ...
AFAIK the simple answer is no because those built in gradient conditional formatting do not allow formulas and custom formulas don't give the option to do a gradient of fill colors.
A possible workaround is to create a helper column that converts the days late to a % days late based on the department acceptable range and use that for your conditional formatting.