Conditional cell formatting

Is it possible to autoformat spreadsheet like this

开发者_JAVA技巧

IF A1 = C1 then A1:E1 background should become light gray

---

Note the yellow highlights,

1. Conditional Formating
2. Formula =$A$1=$A$3
3. Color Background
4. Applies to range =$A$1:$E$1

---

Ok I know how to do it, if anyone cares, you do like @Eric Fortis but:

1. formula should be =$A1=$A3
2. applies to range =$A1
3. copy cell A1
4. select area where you want to do formatting
5. home tab, click on paste dropdown menu
6. choose special paste
7. choose only pasting formats