MushtaqKadar
New Member
Hi,
I have a pivot table with data columns and I need to apply conditional formatting on 3 columns based on the following criteria.
1. Action Status column as "Completed" should be highlighted as green.
2. Action Deadline Date column should be red if the action status is not completed and the action deadline date has exceeded todays date.
3. Date Action Completed column should be yellow if it passes the Action Deadline date.
Any help will be highly appreciated.
Regards,
Mushtaq
I have a pivot table with data columns and I need to apply conditional formatting on 3 columns based on the following criteria.
1. Action Status column as "Completed" should be highlighted as green.
2. Action Deadline Date column should be red if the action status is not completed and the action deadline date has exceeded todays date.
3. Date Action Completed column should be yellow if it passes the Action Deadline date.
Any help will be highly appreciated.
Regards,
Mushtaq
