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?