conditional formatting colour

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Conditional Formatting - Colour Scales

Conditional Formatting - Colour Scales

resolvedResolved · High Priority · Version 2007

Edited on Tue 18 Oct 2011, 16:06

Amy has attended:
Excel Advanced course
Word Advanced course
PowerPoint Intermediate Advanced course

Conditional Formatting - Colour Scales

Hello,

I have produced some tables in excel and formatted them using conditional formatting with colour scales, however, when I copy and paste the table into word 2007 the colour scales do not appear. Do you know if there is anyway to do this? Additionally, when refreshing data in the table the colour scales delete completely, is there a way of retaining the scales when refreshing the spreadsheet?

Many thanks,

Amy.

RE: Conditional Formatting - Colour Scales

Hi Amy,

Should work ok. Can you send me the table your working on?

paul@stl-training.co.uk

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

DATEDIF function

The DATEDIF function is a worksheet function that computes the difference between two dates. This function is documented only in the help files for Excel 2000. It isn't documented in Excel 2002.
the formula function is:
=DATEDIF(Your age,Today(),"Y")
Y stands for year

View all Excel hints and tips


Server loaded in 0.08 secs.