up vote 4 down vote favorite
share [g+] share [fb]

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?

link|improve this question
100% accept rate
feedback

2 Answers

up vote 2 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

link|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
feedback
up vote 2 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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