Forum Discussion
Janice Jorgensen
Dec 20, 2018Copper Contributor
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...
Tanya Denton
Dec 20, 2018Iron Contributor
Hi, based on your spreadsheet, select cells B7 down to B151, then go to conditional formatting create a new rule ([Use a formula to determine which cells to format] option) and in the formula put =B7>A7, set the format required and then apply. Attached the file with the formula.