I need to add a conditional format to multiple rows (i.e. format a2 if a1 = value, format b2 if b1 = value, etc.) but conditional formatting requires =$A$1 so I can't just drag the formatting across cells.
Any suggestions would be greatly appreciated!
Any suggestions would be greatly appreciated!