Results 1 to 4 of 4

How do I make a cell in a work sheet turn green if the same sell on sheet two has an X

Threaded View

  1. #1
    Registered User
    Join Date
    01-28-2010
    Location
    Ontario
    MS-Off Ver
    Excel 2016
    Posts
    43

    How do I make a cell in a work sheet turn green if the same sell on sheet two has an X

    Excel 2016

    Good evening. I am trying to build a work book that I can have a series of work sheets that I can track keywords on social media. i want to have one sheet (Sheet 1) that has all my key words down the left column and dates of posts across the top. I will check off the keywords used on a given day with an X. On subsequent pages I will have the same format how ever the matching cells from sheet one will cause the same cell on "sheet 2" to turn green if there is an x.


    Thanks in advance
    Last edited by Hitman Hotrods; 01-27-2022 at 09:57 PM. Reason: Moderator instruction

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional formating based on other conditional formating?
    By OldManExcellor in forum Excel General
    Replies: 11
    Last Post: 09-14-2014, 02:20 PM
  2. Replies: 5
    Last Post: 03-14-2014, 04:03 AM
  3. Replies: 4
    Last Post: 01-23-2014, 10:14 AM
  4. Conditional formating-What formula do i need to use in conditional formating
    By warrima in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2009, 12:33 AM
  5. Replies: 6
    Last Post: 08-14-2006, 05:00 PM
  6. Replies: 2
    Last Post: 03-27-2006, 12:10 PM
  7. Install dates formating using conditional formating?
    By Jerry Eggleston in forum Excel General
    Replies: 2
    Last Post: 11-09-2005, 01:49 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1