Expanding Conditional Format Rule to entire Column

K

KKD

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?
 
J

Jacob Skaria

Copy cell A5
Select the range you need to apply.
Right click>Paste Special
Select Formats. OK//
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top