Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Color in cells
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 08-13-2018, 06:26 AM
p45cal's Avatar
p45cal p45cal is offline Color in cells Windows 10 Color in cells Office 2016
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
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

« Previous Thread | Next Thread »


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
Color in cells 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
Color in cells Counting Color in Cells Alaska1 Excel 7 07-28-2013 04:36 PM
Color in cells Need cells to autofill with color Silver Rain 007 Excel 1 10-22-2009 08:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:52 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft