开发者

Conditional cell formatting

Is it possible to autoformat spreadsheet like this

开发者_JAVA技巧

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


Conditional cell formatting

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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜