As example, I have 4 columns (from Cell A1 to Cell D1) that store data as follows:
Macedonia 0 1 England
(Columns B and C are numerical)
I want to do a formula/function that will check which Column (B or C) have higher value - if B1 > C1, highlight Cell A1 with green background, if B1 < C1, highlight D1 with green background, if B1 = C1, highlight both A1 and D1 with yellow background.
Is that possible in Ms Excel ?
If not, any other software that have that ability ?
Macedonia 0 1 England
(Columns B and C are numerical)
I want to do a formula/function that will check which Column (B or C) have higher value - if B1 > C1, highlight Cell A1 with green background, if B1 < C1, highlight D1 with green background, if B1 = C1, highlight both A1 and D1 with yellow background.
Is that possible in Ms Excel ?
If not, any other software that have that ability ?