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 » excel vba training - Colour Coding
excel vba training - Colour Coding
Resolved · Low Priority · Version Standard
Wed 30 May 2007, 14:13Delegate Mark said...
Mark has attended:
Excel Introduction course
Colour Coding
how would you colour code data?
for example 1 row red second row blue?
Fri 1 Jun 2007, 09:56Trainer Richard said...
RE: Colour Coding
You can format each row in the colour you want. Then you could use the Format Painter to copy only the format to the rows below. Or you could do it maunally
ie:
Format 1st row red
Format 2nd Row blue
Select both rows
Select Format Painter
Click on next set of rows.
Repeat
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:Working with 3D formulasYou can only use fill-down if you remove $ for Absolute References. |
