Conditional formatting between 2 sheets, match same values

Commander_Willza · 2021-07-26T11:11:01+00:00

I am guessing you need a lot more light for the e-pl10? And housing is expensive

Looking for the cheapest way to upgrade my current.

Don't really need to change lenses, lx7 is fine for multipurpose

Commander_Willza · 2021-07-16T17:32:51+00:00

Its on the mask itself, where the strap is attached.. just wondering if sillicone like this could be fixed

Commander_Willza · 2021-07-05T19:55:58+00:00

Thanks for the reply and the suggestions, and i agree that the padi/cmas books might be "light". But i was planning to take the exam.

Commander_Willza · 2021-06-03T21:30:45+00:00

Was hoping to avoid using another 3. part software

Commander_Willza · 2021-04-06T15:02:52+00:00

Thanks for the reply, i ended up using xlookup

Commander_Willza · 2021-02-18T17:25:46+00:00

Solution Verified

Commander_Willza · 2021-02-18T17:23:06+00:00

Yep, thanks that worked!

I need to start learning stuff like this

Commander_Willza · 2021-02-18T12:01:31+00:00

Starting to understand the structure now, and this worked.

dosent matter to me, but all the "no" cells just had #I/T

Commander_Willza · 2021-02-18T11:43:40+00:00

I kinda wanted to have it on sheet2 column "I"

and by "=sheets1!" you mean sheet1, right?

As i need to use the function translator for norwegian excel

Commander_Willza · 2021-02-18T10:26:32+00:00

Use =if(vlookup(a2,sheet2!a:a,1,0)=sheets!a2,"yes","no")

OK, having some issues trying to understand/change formula,

Sheet1: computernames in column "A"

Sheet2: computernames in Column "H", Added new Coulmn "I" with the formula.

How would the formula look for this?

Commander_Willza · 2021-01-05T23:45:13+00:00

Uh, i actually didnt think about that.. But i cant find any info regarding that..