Hello Everyone,
My name is Snehal and I have just joined this forum because i wanted some help. I have been using open office (4.1.5 with Mac 10.10.5) recently so have some problems figuring it out.
So here goes. I have an excel and have 11 columns. I want to change the background of a cell based on the values from 2 different columns.
So I have columns A and B which contains yes and no values and column C contains numeric values
So if A$1 = y and B$1 = y then the background for values in column C should become green.
And if A$2 = n and B$2 = n then the background for values in column C should become red.
I have been trying a lot but i am not getting a solution. It will be great if somebody can help. I am attaching the file as well which contains only the three columns.
Thank you. Hope to hear soon.