+ Reply to Thread
Results 1 to 2 of 2

Highlight cells that are equal to or greater than 1000

  1. #1
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    403

    Highlight cells that are equal to or greater than 1000

    im trying to highlighted Cells where the cheque number is greater or equal to 1000

    but it highlights all cells

    (See Attachment)

    because of the nature of the book i cant upload any more screen shots

    TIA
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Highlight cells that are equal to or greater than 1000

    Maybe
    =and(C5<>"EFT",C5>=1000)

+ 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. Using greater than or equal to function for a range of cells.
    By chkn89 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2020, 03:12 PM
  2. VBA Highlight duplicates in a concatenated column with over 1000 characters in some cells
    By StaceyFCreative in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-16-2019, 01:19 PM
  3. Highlight cells if value greater than 1 second
    By chrisellis250 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-01-2019, 05:22 PM
  4. Highlight if cells are equal AND contain certain value
    By dgroshan18 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-10-2018, 09:03 PM
  5. If statement for total is greather of equal 2 and 2 cells greater than zero
    By Faridwahidi in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-02-2014, 01:25 AM
  6. [SOLVED] Conditional formatting if equal or greater than average in the range of cells
    By Abu Abdurakhim in forum Excel General
    Replies: 7
    Last Post: 05-28-2013, 10:01 AM
  7. Colouring cells based on equal to or greater than value in another cell
    By bexybeeuk in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-14-2011, 11:47 AM

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