Hope I'm posting in the correct location. This is the first time I've used this.
I'm using conditional formatting to highlight a cell that has the same value of a range of 5 other cells. The rule reads
=$A$4,$H$2:$L$2 and it works fine. The problem is when I try to copy it to cell A5. The rule changes to
=$H$2:$L$2,$A$4:$A$5 and I didn't want to include cell A4. I tryed to change the rule in A4 by deleting the dollar sign to read =$A4,$H$2:$L$2 but excel automatically re-inserts the dollar sign. Is there anyway to accomplish this without having to setup conditional formatting on each individual cell?