+ Reply to Thread
Results 1 to 2 of 2

if data is in cells more than 3 times

  1. 03-11-2018, 10:11 AM #1
    murray83
    murray83 is offline
    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 

    Please Login or Register  to view this content.
    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
    Reply With QuoteRegister To Reply
  2. 03-11-2018, 11:03 AM #2
    murray83
    murray83 is offline
    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 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Fetch data from web data source multiple times with parameters from different cells
    By vipett in forum Excel Programming / VBA / Macros
    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. Count-mark cells that have the same value X times in a row with invalid data in between?
    By DougHarty in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1