Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 07-07-2021, 01:10 AM
allex011 allex011 is offline Cell fill based on conditional formatting Windows 7 32bit Cell fill based on conditional formatting Office 2007
Advanced Beginner
Cell fill based on conditional formatting
 
Join Date: Dec 2017
Posts: 40
allex011 is on a distinguished road
Default

I need help solving the problem. I need to put on SharePoint an excel file that would be populated with data, but if some data is repeated in three cells within in single row in two sheets conditional formatting will change color of cell. But I dont know how in sheet2 column C to return value from row that is duplicated (I color cell in sheet2 in excel file in attachment).Is it possible solve this only with formulas?
Thanks in advanced
Attached Images
File Type: jpg Picture.jpg (41.5 KB, 16 views)
Attached Files
File Type: xlsx sharepoint.xlsx (21.7 KB, 9 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
How to fill a cell at row and column intersection with conditional Formatting Iraj Excel 10 12-02-2017 09:54 AM
Conditional Formatting based on Value of Another Cell SteveBump Excel 3 03-07-2014 09:16 AM
Cell fill based on conditional formatting Conditional formatting question based on cell date Cosmo Excel 2 04-08-2013 12:12 PM
Conditional Formatting Expiration Dates Based on Text in Adjacent Cell Frogggg Excel 1 10-25-2011 08:44 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead Learner7 Excel 0 07-08-2010 05:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:32 AM.


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