Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

conditional formatting data rang

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting, Data Range

Conditional Formatting, Data Range

ResolvedVersion 2003

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.

Thu 22 Apr 2010: Automatically marked as resolved.

Excel tip:

Move or Highlight Cells

Use any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move.

Use in combination with the Ctrl key for quicker movements.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.