conditional Formatting in certain text on a pivot Table
Results 1 to 4 of 4

Thread: conditional Formatting in certain text on a pivot Table

  1. #1
    Board Regular
    Join Date
    Jun 2006
    Posts
    5,326
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default conditional Formatting in certain text on a pivot Table

    I have tried to apply CF to use fill color Blue to Highlight Col A:C where "Total Sales WIP" appears in Col A


    It would be appreciated if someone could assist me, by providing the steps to do this

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,045
    Post Thanks / Like
    Mentioned
    52 Post(s)
    Tagged
    11 Thread(s)

    Default Re: conditional Formatting in certain text on a pivot Table

    Select columns A:C for all rows you want to apply the Conditional Formatting to, then enter the following CF formula (in this example, I am assuming row 2 is your first row):
    Code:
    =$A2="Total Sales WIP"
    and then choose your desired formatting.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    MrExcel MVP
    Join Date
    Aug 2010
    Location
    Rio de Janeiro BRAZIL
    Posts
    16,228
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    8 Thread(s)

    Default Re: conditional Formatting in certain text on a pivot Table


  4. #4
    Board Regular
    Join Date
    Jun 2006
    Posts
    5,326
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: conditional Formatting in certain text on a pivot Table

    thanks for the help.


    managed to get the CF to work

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •