Copy conditional format using formula to entire worksheet

[DOOGIE]

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?

 

[Mike H]

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