Copy conditional format using formula to entire worksheet
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?
|