How can I fill color in one cell related to another cell values. For example:
If 10A10, A2 to be filled with yelow. If A1<0, A2 to be filled with red. I
want to use this in a maintenance worksheet.