Expanding Conditional Format Rule to entire Column

's Computer Specifications

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

's Computer Specifications

Copy cell A5
Select the range you need to apply.
Right click>Paste 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

's Computer Specifications

Copy cell A5
Select the range you need to apply.
Right click>Paste 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting Applying Rule to Entire Column	Vince Pacella	Microsoft Excel Misc	2	1st Dec 2009 10:00 AM
Conditional format entire column	JC	Microsoft Excel Worksheet Functions	3	30th Jun 2009 05:14 PM
Expanding Conditional Format Rule to entire Column	KKD	Microsoft Excel Misc	0	27th May 2009 07:49 PM
Conditional Format overwrighting previous conditional format	davethewelder	Microsoft Excel Programming	2	10th Apr 2008 04:01 PM
New Conditional Format Overriding Previous Conditional Format	Rene	Microsoft Excel Misc	3	27th Feb 2008 07:08 PM