Dec 20 2018 11:08 AM
Want to know how to do conditional formatting when
comparing one cell to another in each row
Each row the cell comparison value is different.
So i want the cell Aves Totales to chnage color when its cell is greater than Aves de 2018 for each row.
I can do this manually---row by row.. but when i use paintbrush it doesn't work.. Hoping some one can help me. i have attached the file.
Aves de 2018 | Aves Totales | Bird Species |
5 | 6 | Little Tinamou |
1 | 0 | Black-bellied Whistling Duck |
5 | 7 | Gray-headed Chachalaca |
1 | 0 | Wood Stork |
Dec 20 2018 03:02 PM
Hey! From what I understood, you simply wanted the "Aves Totales" row to change color every time a number was higher than "Aves de 2018"? Look at the attached file. I hope this helps!.
1st - Select A7 & B7
2nd - Go to "Conditional Formatting" button
3rd - Click, "New Rule:
4th - Click, "Format Only Cells That Contain"
5th - Set up: Format Only Cells That Contain -> Cell Value -> Greater Than -> =$A7 (Make sure you have that dollar sign next to the A to lock the column.)
6th - Format the colors that you'd like
7th - Drag down and fill only the formula to the cells your want.
Hope this helps!
Dec 20 2018 03:04 PM