|
|
|
|
#1
07-07-2021, 10:30 AM
|
|||
|
|||
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 
|
|
|
|
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 |
 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 |
Windows 10 
Office 2019
Hybrid Mode