Kadri has attended:
Excel Advanced course
Conditional Formatting, Data Range
Hi,
I have taken over someone else's spreadsheet and want to see the data range their conditional formatting applies to.
Can you help me with how to do this?
Thanks,
Kadri
RE: Conditional Formatting, Data Range
Hi Kadri, thanks for your query. Use CTRL+G to display the Goto dialog box and click the "Special" button, bottom left. Then choose "Conditional Formats" from the list (should be towards the bottom right) and hit OK. Every cell with a conditional format applied to it will then be selected.
Hope this helps,
Anthony
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.