Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 08-12-2018, 05:39 AM
Stefaan1973 Stefaan1973 is offline Windows 10 Office 2016
Novice
 
Join Date: Aug 2018
Posts: 3
Stefaan1973 is on a distinguished road
Default Color in cells

hi everyone,

I would like to give a color to a date in sheet 1 if the date exists in sheet 2
how can i doe this?


it's also possible that the date exists multiple times in sheet 2
Reply With Quote
  #2  
Old 08-12-2018, 07:44 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,126
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Just use conditional formatting
Not using XL 2016 I don't know how that works between different sheets
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Reply With Quote
  #3  
Old 08-13-2018, 06:26 AM
p45cal p45cal is offline Windows 10 Office 2016
Competent Performer
 
Join Date: Apr 2014
Posts: 147
p45cal is on a distinguished road
Default

Excel 2016/365 has no problem using another sheet in conditional formatting. The formula might be along the lines of =ISNUMBER(MATCH(E5,Sheet2!$A$1:$A$24,0)) but if you could supply a file with sample data we could give a more definitive answer.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting to color cells based on number kallard Excel 4 12-26-2016 11:10 AM
Color-fill a range of cells, based on text in a different sheet. Possible? unittwentyfive Excel 2 06-01-2014 06:48 AM
How can I count cells based on their fill color that was set by conditional format trueimage Excel Programming 1 10-25-2013 12:08 PM
Counting Color in Cells Alaska1 Excel 7 07-28-2013 04:36 PM
Need cells to autofill with color Silver Rain 007 Excel 1 10-22-2009 08:19 PM


All times are GMT -7. The time now is 04:55 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft