I do not have a lot experience with excel conditional formatting.
I need help with this situation.
I have e.g. Workbook named “ Test” with a spreadsheet “Test_A”.
in Test_A spreadsheet I have column A populated with data in it and column B populated with alphabet data.
I need to put condition to color column A cell in yellow when value of column B is “X” in the same row.
How to this in side the same spreadsheet (Test_A) and how to do this if it column “B” is in another spreadsheet Test_B.