Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-05-2021, 05:25 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: 39
allex011 is on a distinguished road
Default Cell fill based on conditional formatting


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 Files
File Type: xlsx sharepoint.xlsx (10.2 KB, 12 views)
Reply With Quote
  #2  
Old 07-05-2021, 11:31 AM
Purfleet Purfleet is offline Cell fill based on conditional formatting Windows 10 Cell fill based on conditional formatting Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

2 Conditional formats
Attached Images
File Type: jpg 2 cond format.jpg (48.1 KB, 14 views)
Attached Files
File Type: xlsx sharepoint_AR12.xlsx (12.7 KB, 5 views)
Reply With Quote
  #3  
Old 07-05-2021, 01:38 PM
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: 39
allex011 is on a distinguished road
Default

I was thinking excell based on values in three cell(one in first sheet, and another two in second sheet) returns automatically value in threed column (like in the excel file that I attached).
Reply With Quote
  #4  
Old 07-05-2021, 05:48 PM
Purfleet Purfleet is offline Cell fill based on conditional formatting Windows 10 Cell fill based on conditional formatting Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Sorry i dont understand what you mean
Reply With Quote
  #5  
Old 07-07-2021, 01:02 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: 39
allex011 is on a distinguished road
Default

is there a possibility that, if the conditional formatting for the three cells is met, excel itself fill data from the above cells using the formula in row under
Reply With Quote
  #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: 39
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, 13 views)
Attached Files
File Type: xlsx sharepoint.xlsx (21.7 KB, 7 views)
Reply With Quote
  #7  
Old 07-07-2021, 08:35 AM
Steve Kunkel Steve Kunkel is offline Cell fill based on conditional formatting Windows 10 Cell fill based on conditional formatting Office 2019
Advanced Beginner
 
Join Date: May 2019
Location: Seattle area
Posts: 77
Steve Kunkel is on a distinguished road
Default

The way conditional formatting works is that "if some calculation = true" then apply the color. For example, "if A1 = x." So can you just use the same calculation in the above cells? Like "if A1 = x, then return C6, otherwise do something else."
Reply With Quote
  #8  
Old 07-07-2021, 10:30 AM
Purfleet Purfleet is offline Cell fill based on conditional formatting Windows 10 Cell fill based on conditional formatting Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

So you are matching Cappuccino on Sheet1 with 2.25 and 2.95 on Sheet2 based purely on position on the sheet?

You could get Index and match to do it but column C can only be Either a typed cell or a formula

On the attached i have added column C as a formula so if you add in a duplicate it will find the first one in the previous cells, but if its not found it will say #ref and you will need to over type.

You could do simular with an extra column that might look better
Attached Files
File Type: xlsx sharepoint_AR12-2.xlsx (14.1 KB, 5 views)
Reply With Quote
Reply

Thread Tools
Display Modes


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:15 PM.


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