jackmanjls
Member
I want to color more than 1 cell based on the values of 2 cells. I know how to write the cond. format rule to color a single cell.
For example, assume that there are 2 cols names plus and down. The following logic would be used to color the cells.
if plus<300 and down<300 and plus<down then plus=pink, down=pink
if plus >=300 and down down<300 then plus=dark green, down=green
if plus<300 and down >300 then plus=green, down=red
So, to clarify the issue I want to implement the if statement and color both the plus and down cells based on the logic in the if statement.
For example, assume that there are 2 cols names plus and down. The following logic would be used to color the cells.
if plus<300 and down<300 and plus<down then plus=pink, down=pink
if plus >=300 and down down<300 then plus=dark green, down=green
if plus<300 and down >300 then plus=green, down=red
So, to clarify the issue I want to implement the if statement and color both the plus and down cells based on the logic in the if statement.
