I want to highlight cell A1 through A5 a different color based on if there is
a number 1 in cell A6,A7,A8 or A9. There will only be a 1 in one of the 4
cells. I do not want the 4 cells to be highlighted. I have used conditional
formatting for a single cell but can not figure out how to do it this way.
Thank you for your help.