Conditional Formatting Dates
Is there a way to have a dates turn a color?
I need dates on a pinboard or entire rows to turn a color once a date has been reached. As in -- at date on an established pinboard is 90 days old I want it to change colors or a date that falls in a range I specify by formula or otherwise turns a color.
Gary Clothier You can explore Conditional Formatting in tables view.
But there are same limitation:
- Conditional formatting only apply for column only
- We can not use logic for checking value another column and apply the color coding to other column.
- No option for conditional formatting in Pivot table