+ Reply to Thread
Results 1 to 3 of 3

Using COUNTIF to Conditionally Format Cells

  1. #1
    Registered User
    Join Date
    06-04-2014
    Posts
    1

    Using COUNTIF to Conditionally Format Cells

    I am attempting to create a staffing calendar that will use conditional formatting to alert the coordinator by highlighting the cell when certain thresholds are reached.

    The spreadsheet has three tabs, with 'Master' being the final copy.

    In the 'Magic' tab, I was able to get it work with a rolling count but I am having trouble recreating it when the count is stationary and not updating itself line by line aside the person's name.

    What I'm preferrably looking to have happen is for the 'Name' to light up when it appears more than 3 times in a week in the Day fields, more than 1 time a week in the O/C field and more than 7 times a month in the Night field.

    Any and all help would be truly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    10-07-2011
    Location
    India, Mumbai
    MS-Off Ver
    Excel 2007
    Posts
    212

    Re: Using COUNTIF to Conditionally Format Cells

    Your attached sheet data is not updated per your requirement and you have not mentioned in which sheet and cell you want formatting.

    Regards,
    Suhas

  3. #3
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,833

    Re: Using COUNTIF to Conditionally Format Cells

    Hi ,

    Could u provide a before and after sheet for better understanding.

    I have made some changes in magic sheet .

    Use this condition

    =IF((COUNTIF($A$2:A2,A2))>4,"TRUE","FALSE")

    Punnam

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to compare cells and format conditionally over a whole sheet
    By HilaryP in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-30-2014, 10:33 AM
  2. Macro to Conditionally Format Cells based on another cells value
    By Barking_Mad in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-07-2013, 03:05 AM
  3. Replies: 6
    Last Post: 10-13-2011, 11:30 AM
  4. Replies: 2
    Last Post: 04-06-2006, 11:10 AM
  5. [SOLVED] conditionally format cells
    By elad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2005, 01:06 PM

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