Is it possible to autoformat spreadsheet like this
IF A1 = C1 then A1:E1 background should become light gray
Ok I know how to do it, if anyone cares, you do like @Eric Fortis but:
=$A1=$A3
=$A1