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

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