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 online now Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,228
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
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)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
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: 205
p45cal will become famous soon enough
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 08:44 AM.


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