I have a fairly simple spreadsheet and I have set up a conditional statement to make the cell backgrounds in column 5 switch colors based on a simple greater than statement. I would also like to have column two syncronize and switch background colors based on the value in column 5 as well. What is the easiest way to acheive this? Is a macro required?
Thanks in advance.
Ryan
Thanks in advance.
Ryan