I am using conditional formatting to change the format of rows based on the
value of a cell in that particular row. I need to do this for the entire
worksheet. How can I easily do this without having to enter the conditional
format for each individual row?

Hi,

Check the 'Formatting' toolbar is visible and if it isn't display it with

View|Toolbars and select formatting

Select the row that has the conditional format in and then click the format
painter on the toolbar - It looks like a paintbrush.

Click into the top left cell where you want the format painted and hold down
the left mouse button and drag the format to the desired range.

Mike


"DOOGIE" wrote:

> I am using conditional formatting to change the format of rows based on the
> value of a cell in that particular row. I need to do this for the entire
> worksheet. How can I easily do this without having to enter the conditional
> format for each individual row?