I have condintional formatting for cell J1. If cell value J1 <-0.1 font is
green. If cell value J1 between 0.1 and -0.3 font is orange. If cell value
J1 <-0.3 font is red. Through J10.

Now I need Cell B1 through B10 to match in color with J1 through J10. My
issue is that there is a calculation already done in B1 through B10. I can't
do a Conditional Formatting and If J1 is orange then B1 orange. Or If J10 is
red the B10 is red.