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?