Results 1 to 2 of 2

condition format same value pattern become red

Threaded View

  1. #1
    Forum Contributor choy96's Avatar
    Join Date
    03-19-2010
    Location
    singapore
    MS-Off Ver
    Excel 2019
    Posts
    187

    condition format same value pattern become red

    sometime type order have been make mistake that double key in, may i have a conditional format that if i key order no ABC1122 into A5 , it will check whether A1 to A4 and A6 to A100 have the same value, if it is true, its pattern become red.

    please help, thanks.
    Last edited by choy96; 11-28-2010 at 08:40 AM.

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