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,
- Conditional Formating
- Formula
=$A$1=$A$3
- Color Background
- Applies to range
=$A$1:$E$1
Ok I know how to do it, if anyone cares, you do like @Eric Fortis but:
- formula should be
=$A1=$A3
- applies to range
=$A1
- copy cell A1
- select area where you want to do formatting
- home tab, click on paste dropdown menu
- choose special paste
- choose only pasting formats
精彩评论