Please do not SHOUT! It is considered to be very bad netiquette.
Select the rows/columns by using the number or letter
headers>format>cells>patterns>select a color. OR,use the built in on your
toolbar.
To change all cells use the cells button on top of the 1 and to the left of
the A