I have attached a spreadsheet with a Pivot Table report.
I am trying to add a Conditional Formatting to the report. The criteria for this report is to check for a dummy date of 01/01/1900. This is used to illustrate any projects cancelled or on hold.
I wanted the ability to grey out the entire row if the date in Column D (Actual Completion Date) =1 (or 01/01/1900).
However I can only seem to highlight Column A. I do this by placing the cursor between rows 7 and 8 and you get the downward pointing black arrow. I then left click the mouse and this highlight column A in the rows that contain data (the rows with the dates etc).
If you open the attached workbook, you will Column A is highlighted as per the Condition Formatting, I cannot work out how to extend this formatting to the entire row.
I would be grateful if someone could explain how to set the formatting for the entire row where the data is displayed.