+ Reply to Thread
Results 1 to 2 of 2

if data is in cells more than 3 times

Hybrid View

  1. #1
    Forum Contributor murray83's Avatar
    Join Date
    05-05-2016
    Location
    Daventry
    MS-Off Ver
    365
    Posts
    146

    Cool if data is in cells more than 3 times

    have done conditional formatting with the following formula

    =COUNTIF($G$2:$G$154,G2)>3
    but it only seems to update the text as the column has text and numbers, but it ignores the numbers any ideas

    formating is on the PC List sheet
    Attached Files Attached Files

  2. #2
    Forum Contributor murray83's Avatar
    Join Date
    05-05-2016
    Location
    Daventry
    MS-Off Ver
    365
    Posts
    146

    Re: if data is in cells more than 3 times

    figured out was my own silly fault see code below

    =COUNTIF($G$2:$G$154,$G2)>2

+ 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. Replies: 0
    Last Post: 03-01-2017, 06:19 AM
  2. Macro to copy group of cells and paste multiple times for each row of data
    By muddakinjaz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2016, 01:17 PM
  3. Replies: 1
    Last Post: 12-12-2014, 11:51 AM
  4. If a search term can be found 1 time, 2 times 3 times 4 times 5 times
    By excelcandy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2013, 09:57 PM
  5. Find percentage of times two adjacent cells have the same data
    By jamie_bisson in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-26-2013, 01:53 AM
  6. [SOLVED] Comparing Times in Text Boxes to Times in Cells
    By Matt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-05-2006, 11:15 PM
  7. [SOLVED] Charting and analyzing Times' times data for trends
    By Johnny in forum Excel General
    Replies: 1
    Last Post: 05-04-2005, 09:06 PM

Tags for this Thread

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