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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel learn london - Formatting Cell range

excel learn london - Formatting Cell range

ResolvedVersion Standard

Thu 10 Jan 2008, 16:09 Delegate Dipesh said...

Dipesh has attended:
Excel VBA Intro Intermediate course

Formatting Cell range

How can I create a marco to format a range of cells, but with varying formats. E.g The headers are formated with a blue fill and white font, and the body of the range white fill with black font and borders?

Thu 10 Jan 2008, 16:43 Delegate Paul said...

RE: Formatting Cell range

Tools > Macros > record new macro

then do the formatting.

then press stop

then attach the macro to a button

then whenever you want to format the cells in this way, press the button

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Registered in England and Wales.

Terms & Conditions Privacy & Cookie Policy