Forum Discussion
conditional formatting for two columns. Cells in new rows in column have different value.
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 i...
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!