#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
Just use conditional formatting
Not using XL 2016 I don't know how that works between different sheets
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
||||
|
||||
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.
|
|
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 |