Hello all,
How do I set the Max value taken from a range comprising of just two cells. I noticed that I cannot use relative references with conditional formatting. Hence, is there a way to set the range to the cell where conditional formatting resides and the other one just at adjacent to it on the right.
for instance, CF resides at B1 and B1 has a value 10, and then the adjacent cell C1 has a value of 15. So, I have my two cells B1 and C1 and the formula must output 15 to be used for the conditional formatting's formula box. then if I copy and paste this conditional formatting to cell B2 the formula should set the range to B2 and C2.
can happen?
Thank you and much appreciation.
How do I set the Max value taken from a range comprising of just two cells. I noticed that I cannot use relative references with conditional formatting. Hence, is there a way to set the range to the cell where conditional formatting resides and the other one just at adjacent to it on the right.
for instance, CF resides at B1 and B1 has a value 10, and then the adjacent cell C1 has a value of 15. So, I have my two cells B1 and C1 and the formula must output 15 to be used for the conditional formatting's formula box. then if I copy and paste this conditional formatting to cell B2 the formula should set the range to B2 and C2.
can happen?
Thank you and much appreciation.