Results 1 to 2 of 2

need a conditional formatting formula for this situation

Threaded View

  1. #1
    Registered User
    Join Date
    03-21-2023
    Location
    japan
    MS-Off Ver
    360
    Posts
    1

    need a conditional formatting formula for this situation

    I have two sheets, Sheet 1 and Sheet 2. In sheet one i have lot of cells name TP, TY etc and in sheet 2 i have cells TP, GH and TY. I want a conditional formatiing formula in a way, i want to color my cells red only which are in sheet 2 column D(later i will add more columns) but need a situation like that.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to do a Vlookup in a conditional situation
    By newbiemaster in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-18-2021, 04:32 AM
  2. Offset Situation in Formula
    By ofd2008 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-15-2014, 09:04 AM
  3. [SOLVED] Conditional Formatting (Colors) in a "Nested If" Situation
    By ikslohap in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-17-2014, 11:28 AM
  4. Need formula for an either-or/both situation
    By Lorbiculous in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-07-2014, 01:49 PM
  5. [SOLVED] Conditional formatting for not equal to situation
    By ROHAN999 in forum Excel General
    Replies: 5
    Last Post: 07-06-2013, 03:46 AM
  6. Replies: 1
    Last Post: 04-10-2009, 10:03 AM
  7. [SOLVED] Conditional Formatting for a range situation
    By JayF in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2006, 04:10 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