How can I specify a sheet as range in Excel?

Question

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.

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

Answer 1

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

Answer 2

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