Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Default Conditional Format Entire Workbook

When selecting the first worksheet and holding down the shift key and selecting the last worksheet in the unprotected workbook, the conditional format is not available. Version is Excel 2007, is there another process for copying the conditional formatting to all worksheets in the workbook?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,514
Default Conditional Format Entire Workbook

Popdaddylee formulated the question :
When selecting the first worksheet and holding down the shift key and
selecting the last worksheet in the unprotected workbook, the
conditional format is not available. Version is Excel 2007, is there
another process for copying the conditional formatting to all worksheets
in the workbook?


CF is sheet-specific. Yo can apply CF to one sheet and copy that sheet,
OR use the FormatPainter tool and copy the formatting to each sheet.
The latter will require selecting all the cells that have the
formatting you want to copy *before* double-clicking the FormatPainter
icon. Be sure to click the icon 'off' when you're done.

Note that you can select the entire sheet by clicking the square above
the row labels, left of the column labels. I don't recommend doing
this, though, because it may take a rather long time depending on how
many sheets you're applying CF to. I'd go with doing sheet1 and then
copy it!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional format entire column JC Excel Worksheet Functions 3 June 30th 09 05:14 PM
Conditional Format entire row CrimsonPlague29 Excel Discussion (Misc queries) 3 March 1st 08 03:04 AM
color entire row by using conditional format capital letter Excel Worksheet Functions 1 November 10th 07 10:55 AM
Conditional format based on entire row LisaVH Excel Worksheet Functions 8 January 17th 07 08:29 PM
Conditional Format to Highlight entire Row? shital shah Excel Worksheet Functions 1 August 25th 05 04:37 PM


All times are GMT +1. The time now is 12:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"