Results 1 to 12 of 12

highlight cell

Threaded View

  1. 06-01-2016, 02:43 AM #1
    ALLANT
    ALLANT is online now
    Registered User
    Join Date
    04-13-2016
    Location
    Laguna Philippines
    MS-Off Ver
    O365 PRO PLUS
    Posts
    69

    highlight cell

    I have a spreadsheet file for my monitoring of shipments from abroad and I was hoping someone could help me out for what am trying to do. I have attached a simple workbook.
    1. Is it possible to highlight cell A (light Green) if put the word "closed" in cell Y
    2. Is it possible to highlight cell A (light Red) if put the word "OPEN" in cell Y
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Auto highlight row & column of active cell without deleting existing cell colour
    By claire_wilson in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-22-2017, 08:31 PM
  2. [SOLVED] Highlight cell based on selected cell - Code required
    By SharpL in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-24-2014, 09:48 AM
  3. Highlight a cell based on data in another cell - condition formatting or formula??
    By mak8409 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-20-2014, 03:52 AM
  4. Macro to search and highlight a cell prior to the searched cell
    By gjccks in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 04-15-2013, 01:51 PM
  5. [SOLVED] Highlight active cell, un-highlight when no longer active?
    By cdterry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-20-2013, 02:39 PM
  6. [SOLVED] Locating Duplicate Cell Data with a Cell Counter and Highlight
    By garrett.grillo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-30-2012, 01:46 AM
  7. [SOLVED] Highlight cells with ctrl-click but only un-highlight one cell
    By hagan in forum Excel General
    Replies: 5
    Last Post: 05-27-2005, 02:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1