Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I want to apply conditional formatting on a sheet. I used to do Ctrl + A and then apply the formatting, but when i insert new cells or rows, this isn't included in the formatting. As you can see in the picture below, you have to give a range.

Conditional Formatting

Is it possible to give the entire sheet as range and how to do so?

share|improve this question

2 Answers 2

up vote 3 down vote accepted

For MS Office 2007 and later, use

1:1048576

to select all cells in the entire worksheet.

For MS Office 2003 and earlier, use

1:65536

share|improve this answer
    
i thought there would be something like "worksheet" or something, but seems like there's not so i guess this will do. Thanks. –  Djerry Apr 29 '11 at 9:53
    
@djerry: You're welcome. If it was in VBA, there would be more options. –  Mehper C. Palavuzlar Apr 29 '11 at 10:59

A quick hack is to click the space above the intersection between first row & first column when prompted for a range to apply to

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.