Results 1 to 6 of 6

Conditional Formatting help

Threaded View

putnum Conditional Formatting help 12-22-2009, 06:33 PM
Palmetto Re: Conditional Formatting... 12-22-2009, 06:57 PM
putnum Re: Conditional Formatting... 12-22-2009, 07:04 PM
Palmetto Re: Conditional Formatting... 12-22-2009, 07:28 PM
putnum Re: Conditional Formatting... 12-22-2009, 08:50 PM
Palmetto Re: Conditional Formatting... 12-22-2009, 09:00 PM
  1. #1
    Registered User
    Join Date
    12-12-2009
    Location
    Roanoke TX
    MS-Off Ver
    Excel 2007
    Posts
    50

    Conditional Formatting help

    I need some help with conditional formatting. I have attached a copy of my "budget" for those that can help.


    What i need is whenever you choose a option in A9 on PayCheck - DEC - 09 - B it will count the number of items on the right and hightlight them with a color.

    I use =COUNTIF('PayCheck - DEC-09-B'!E$2:E$1000,A9) in A11 to tell me the number of occurences but I would also like a visual effect with colors.

    Can anybody help with this one?

    Many Thanks,
    Adam
    Attached Files Attached Files
    Last edited by putnum; 12-23-2009 at 06:23 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1