I'm working with Google's spreadsheets to keep a record of how many dragons of each breed/gender I have in a game I play. I have five columns:
A (Breed) | B (Male) | C (Male Goal) | D (Female) | E (Female Goal)
I want to highlight B
with green if it is greater than or equal to C
, red if it is less than C
.
I want to highlight D
with green if it is greater than or equal to E
, red if it is less than E
.
Obviously, I could use conditional formatting for each individual row to achieve this, but there's 116 rows so I was hoping there was a formula that would work for the entire column.
Best Answer
Here is what you can do:
B2
→ select Conditional formatting → select Custom Formula is (from the List)=b2>=c2
=b2<c2
B2
and click on Paint Format option on the tool bar.B3
and drag until cell -B117
(this should apply the conditional formatting on cell ranging fromB3
-B117
)And for your second condition (i.e., to highlight
D
with green if it is greater than or equal toE
, red if it is less thanE
) - simply repeat the above steps by interchangingD2
forB2
andE2
forC2
.