Avatar of Jase Alexander
Jase Alexander
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Excel Lookup / Match across two worksheets and return red cells on both in one list

Hi Experts

Ive just received some excellent assistance on the attached workbook however there is one more (final) item Im struggling with

On the first tab - Completed - to the right is a section saying Total of Red on Both

Is there a way to look across two worksheets - Results Units and Results Costs - and if a red cell appears on both, to list this on the front sheet under the above title - or set it up on both so I can drag the results onto the Completed tab?

If it did not involve conditional formatting and colour I dont believe I would have an issue however Im not sure if its possible to include the colour variable into the lookup / syntax?

Any suggestions would be welcome

J
Copy-of-Cycle-count-pick-face-map-2.xlsm
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Jacques Geday

8/22/2022 - Mon