Share via

Only print conditional formatted cells?

Anonymous
2015-06-03T15:24:58+00:00

I have a sheet with 400 members (rows) . One column is their membership expiration date and I have a conditional format rule to change the cell red when expired. Is there a way for me to ONLY print these red rows (not just cells) ? I usually have about 30-40  per month who are expired and would like to only print these members (rows).

Thanks all.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2015-06-03T15:42:11+00:00

Hi,

You could apply a filter to this range and filter by colour so that only the red conditionally formatted cells are visible and then print the worksheet.

To apply a filter select the header row and then 'Data Tab' - Filter

Click any of the dropdown arrows and select filter by colour and click Red.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more