MobileMobile | Continue

Excel Bar

Excel Bar

Your excel questions will be responsed by our excel experts within 24hrs.Our service is free.

 Forgot Pass?
 Register Now
Find
Hot Search: Vlookup Match VBA
View: 272|Reply: 3

Copying Conditional Formatting to 1000's of cells

[Copy link]

1

Topics

1

Posts

7

Integral

Newbie

Rank: 1

Integral
7
Post on 9-30-2016 19:25:28 | All posts |Read mode
Hi,
I have created a spreadsheet that is a Training Matrix and has 1000's of cells. I have entered conditional formating in all the cells in one column where if the date entered is over a year old then it turns red, if its more than 9 months but less than a year it turns orange and if its within date or N/A then its clear.
My question is, how can i copy and past the same conditional formatting to all of my other cells? I dont really want to enter these formatting in manually to each cell as there are 1000's. If i copy and past it takes the location as well which i dont want it to.
Difficult to explain and for some reason when i click on attach file to this thread i just get a thin blank box. I am happy to email the file to someone. For example. Column H i have entered in the formatting but i need it in the rest of the columns as well.
Cheers Nick




Reply

Props Report

6

Topics

400

Posts

958

Integral

Lord

Rank: 4

Integral
958
Post on 9-30-2016 20:56:20 | All posts



I've posted an answer to your identical question in the Excel Formulas and Functions sub-forum.  For future reference, please don't post the same question in multiple locations - forum members don't want to waste time answering a question in one place which might already have been answered in others.  Thanks.
Reply Support Opposition

Props Report

19

Topics

1896

Posts

4035

Integral

Forum Legend

Rank: 8Rank: 8

Integral
4035
Post on 10-6-2016 15:36:12 | All posts



1. highlight the range you want to apply the conditional formatting to (the range in A)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =B2=F2...format fill your color
This assumes your data starts in row 2 - adjust that as needed
Reply Support Opposition

Props Report

7

Topics

603

Posts

1331

Integral

King

Rank: 6Rank: 6

Integral
1331
Post on 11-15-2016 18:25:56 | All posts



Highlight the rows that you are interested in.
Select conditional formatting, new rule
use this formula



  



      =$Z1=$A1
      
      

Use the Format, Fill colour Red.

Alternatively select all cells by clicking on top left hand corner.
and use this formula to opperate on the top 20 rows only:



  



      =AND(ROW(A1)21,$Z1=$A1)
Reply Support Opposition

Props Report

Points policy of this forum

Archiver|Mobile|Small dark house|Contact us|Excel Bar

GMT-5, 9-24-2017 21:21 , Processed in 0.260355 second(s), 20 queries .

Powered by Discuz! X3

© 2001-2013 Comsenz Inc.

!fastreply! Top !return_list!