98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting, Data Range
Conditional Formatting, Data Range
Resolved · Low Priority · Version 2003
Thu 15 Apr 2010, 11:30Delegate Kadri said...
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
Thu 15 Apr 2010, 11:43Trainer Anthony said...
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
Thu 15 Apr 2010, 11:43Trainer Anthony said...
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding up time greater than 24 hoursWhen you add up time if it exceeds 24 hours i.e 27 hours appears as 03:00. Go to Format / Cells / Number / Custom. The format is hh:mm but if change it to [hh]:mm it will add up to the correct amount of hours. |
