PC Review


Reply
Thread Tools Rate Thread

Expanding Conditional Format Rule to entire Column

 
 
KKD
Guest
Posts: n/a
 
      27th May 2009
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 With Quote
 
 
 
 
Jacob Skaria
Guest
Posts: n/a
 
      27th May 2009
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

 
Reply With Quote
 
 
 
 
Jacob Skaria
Guest
Posts: n/a
 
      27th May 2009
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:36 AM.