|
|
#3
08-13-2018, 06:26 AM
|
||||
|
||||
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 |
Windows 10 
Office 2016
Threaded Mode