Results 1 to 6 of 6

Conditional formatting to highlight same value in same cells on different tabs

Threaded View

  1. #1
    Registered User
    Join Date
    02-16-2021
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    3

    Conditional formatting to highlight same value in same cells on different tabs

    Hi all,

    I'm in need of your expertise.
    I've built a new sheet to use daily, but I need to find a way to make each tab, 2pm - 5pm highlight the cell red if the number 1 is contained in the same cell of the previous tab. 1pm tab is when the initial data is pulled.

    Please see the attached image and a smaller file version for this to make sense.

    So, 5pm, if the number 1 is in the same cell as it is in 4pm tab, it will highlight red on the 5pm tab.
    However, I need this to only match the values in Column E to K, excluding the headers.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by cj2k; 02-16-2021 at 04:35 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 01-01-2021, 05:39 PM
  2. Conditional Formatting - Highlight Cells
    By telcocook in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 05-06-2016, 06:48 PM
  3. Conditional Formatting to highlight cells help!
    By excelnoob7 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-17-2015, 04:19 PM
  4. Replies: 5
    Last Post: 05-18-2013, 07:49 PM
  5. Conditional Formatting - Highlight Cells
    By jfs in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2011, 01:14 PM
  6. Highlight cells with VBA or Conditional Formatting?
    By starcraftbud in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-08-2010, 03:54 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