Forum Discussion

eliseharmonic's avatar
eliseharmonic
Copper Contributor
Feb 21, 2023

Conditional formatting

For the dataset below, I want to create the rules below:

1) if the number in the left hand column is less than half of the one in the right hand column, both cells will highlight red

2) if the number in the left hand column is more than half of the number in the right hand column but not equal to the right hand number, both cells will highlight yellow

3) if the number in the left hand column is equal to or greater than the number in the right hand column, both cells will highlight green

 

We change the numbers in both columns each week so would need a formula that would apply to any numbers, rather than the ones specified above.

 

Thanks!

1 Reply