| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy conditional format using formula to entire worksheet
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I copy an entire worksheet to another with text & format? | Excel Discussion (Misc queries) | |||
| Is it possible to copy a conditional format formula as paste value | Excel Discussion (Misc queries) | |||
| Copy Formula Is conditional format | Excel Worksheet Functions | |||
| How do I copy a conditional format that uses a formula in a serie. | Setting up and Configuration of Excel | |||
| need a formula to copy entire row to next worksheet | Excel Worksheet Functions | |||
Linear Mode
