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: 350|Reply: 5

Copying and Pasting Excel to Powerpoint conditional formatting

[Copy link]

2

Topics

4

Posts

22

Integral

Member

Rank: 2

Integral
22
Post on 9-30-2016 09:16:09 | All posts |Read mode
Hello,

I have a table that contains population densities. A sample can be seen here: http://hastebin.com/ruyojihuri.lisp
This table has rows and columns. My goal is to apply some form of formatting to it to adequately represent the differences in population sizes WITHOUT using color formatting. Is this possible?
Reply

Props Report

19

Topics

1896

Posts

4035

Integral

Forum Legend

Rank: 8Rank: 8

Integral
4035
Post on 10-3-2016 18:10:44 | All posts



1.  Highlight the range you want to use
2.  On Home tab, select CD
3.  Select New Rule, select Use Formula
4. =$A1=completed











Reply Support Opposition

Props Report

2

Topics

188

Posts

466

Integral

Conqueror

Rank: 3Rank: 3

Integral
466
Post on 10-3-2016 19:46:34 | All posts



Is this for Word or for Excel? Ford's advice applies to Excel but you've posted in the Board's Word forum.











Reply Support Opposition

Props Report

19

Topics

1896

Posts

4035

Integral

Forum Legend

Rank: 8Rank: 8

Integral
4035
Post on 10-3-2016 19:54:34 | All posts



Good catch Paul, did not even notice that
Reply Support Opposition

Props Report

2

Topics

77

Posts

206

Integral

Conqueror

Rank: 3Rank: 3

Integral
206
Post on 11-11-2016 23:00:11 | All posts



If there are no duplicates in the left or right columns, go to CF on the Home tab, and using separate clicks to select the columns, highlight cells rules /duplicate values.  Format as desired.
Pete




Reply Support Opposition

Props Report

3

Topics

774

Posts

1691

Integral

King

Rank: 6Rank: 6

Integral
1691
Post on 11-11-2016 23:08:48 | All posts



You can select both columns of data. I used column A as the complete list and column B as the list with possible missing names.
With both lists selected, go to Conditional Formatting, New Rule, Use formula and enter the following in the formula field. Choose the formatting of your choice for the cells that have contents not included in column B. This covers 100 rows but can be extended. The Applies To should show the entire range covered by the rule.


  



      =AND(A1,COUNTIF($B$1:$B$100,A1)=0)
      
      









  • Conditional Formatting.xlsx
    (8.8 KB, 9 views)
    Download

  • Reply Support Opposition

    Props Report

    Points policy of this forum

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

    GMT-5, 11-20-2017 00:42 , Processed in 0.216652 second(s), 20 queries .

    Powered by Discuz! X3

    © 2001-2013 Comsenz Inc.

    !fastreply! Top !return_list!