Hello,
Is there a way to color an entire row based on the color of the cell next to it?
I used conditional formatting on a cell based on a value, but I also need to color the cell next to it (it does not have a value), the cell has a name.
Name Total
John Smith 40
Based on the total the entire row should be
Red. The numbers - 0 - 4 green, 5 to 8
yellow, 5 to 12 orange 13 and up is red
Thank you
Is there a way to color an entire row based on the color of the cell next to it?
I used conditional formatting on a cell based on a value, but I also need to color the cell next to it (it does not have a value), the cell has a name.
Name Total
John Smith 40
Based on the total the entire row should be
Red. The numbers - 0 - 4 green, 5 to 8
yellow, 5 to 12 orange 13 and up is red
Thank you