Sample of conditional formula to be used for conditional formatting and data validation:
For this specific case - only conditional formatting and data validation!
Start with something simple:
For example we want to show in yellow all columns with month > 3
On the report we will have:
And:
Conditional formatting will be applied to the range B2:D2 with the formula:=RIGHT(B$1;2)*1>3
when condition is checked B in this formula will be replaced by: B,C,D from range
Add comment