| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expanding Conditional Format Rule to entire Column
I have a CF rule set up as follows:
if A1 = "Paid", then cell A5 is formatted. How do I expand this rule to encompass to the entire column respectively? -- KKD |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Expanding Conditional Format Rule to entire Column
Copy cell A5
Select the range you need to apply. Right clickPaste Special Select Formats. OK// -- If this post helps click Yes --------------- Jacob Skaria "KKD" wrote: I have a CF rule set up as follows: if A1 = "Paid", then cell A5 is formatted. How do I expand this rule to encompass to the entire column respectively? -- KKD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a range adjacent to Conditional Format - CF Rule adds to P | Excel Discussion (Misc queries) | |||
| Conditional Format entire row | Excel Discussion (Misc queries) | |||
| color entire row by using conditional format | Excel Worksheet Functions | |||
| color entire row by using conditional format | Excel Worksheet Functions | |||
| Conditional Format to Highlight entire Row? | Excel Worksheet Functions | |||
Linear Mode
