Hiya,
I'm pulling my hair out hair trying to get this problem fixed to no avail
I have 5 columns with product prices... Lets say E2 (our price) - F2, G2, H2, I2 (competitors prices)
What I want to do is if the figures in columns F,G,H or I is equal to or less than our price in column E make the figure go red.
I am able to do this for a single cell but It would take me years to format every cell individually as there are over 2000 rows. I keep getting an error when trying to select an entire column.
Please help
I'm pulling my hair out hair trying to get this problem fixed to no avail
I have 5 columns with product prices... Lets say E2 (our price) - F2, G2, H2, I2 (competitors prices)
What I want to do is if the figures in columns F,G,H or I is equal to or less than our price in column E make the figure go red.
I am able to do this for a single cell but It would take me years to format every cell individually as there are over 2000 rows. I keep getting an error when trying to select an entire column.
Please help