I have two different spreadsheets A and B where both of them have a column consisting of server names. Some of the server names are in common and for this I want to make a conditional query in Excel where I first want to check if server names are equal and if so check if a column in A consisting of integer values have a limit of 90. If the server has a corresponding integer value greater than 90 I want to give a color fill in one of the B's column. So roughly a python like pseudo-code would look like:
for i in range(Spreadsheet A: Column 1):
for j in range(Spreadsheet B: Column 1):
if i==j:
if i.column 2 > 90:
color fill j.column2 red
else:
color fill j.column2 green
Aucun commentaire:
Enregistrer un commentaire