rehighlighting condition cells w

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Re-highlighting condition cells without wiping out data in cell

Re-highlighting condition cells without wiping out data in cell

resolvedResolved · Low Priority · Version 2007

Sam has attended:
Excel Advanced course

Re-highlighting condition cells without wiping out data in cell

Once a conditional cell has been used, how can you be notified that it may need to overwritten

RE: Re-highlighting condition cells without wiping out data in c

Hello Sam

Thank you for your question and welcome to the forum.

Can you please explain what you would like to know in a little more detail...I'm unsure what you are asking.

Kind regards
Amanda

RE: Re-highlighting condition cells without wiping out data in c

Hi Sam,

How are you? :)

This question has now been left unattended for a while.

We like to keep down the large number of active forum posts we receive.

As we are waiting for your response for further information to help resolve your issue, we will be automatically marking this question as resolved in the next 5 days (unless you post a follow-up within that time).

We look forward to hearing from you.

Thank you.
Regards, Rich

Wed 20 May 2009: Automatically marked as resolved.


 

Excel tip:

Sorting List Subtotals

If you find that you would prefer to show the items in a subtotalled list in a different order, eg ascending rather than descending, you can sort your list. To sort a subtotalled list, hide the detail rows and then sort the subtotal rows. When you sort a subtotalled list, the hidden detail rows are automatically moved with the subtotal rows.
IMPORTANT: If you do not hide the details rows before sorting a subtotalled list, your subtotals will be removed and all of the rows in your list will be reordered.

View all Excel hints and tips


Server loaded in 0.09 secs.