C-NET :: PROJECTS

cat excel-conditional-formatting.md

Excel Conditional Formatting

Posted
Filed under
Windows · Reference

I don't do much Excel, but when I do, it's crap like this. Putting it here, so I remember.

  • For applying conditional formatting to an entire sheet, do "Applies to: =$1:$1048576"
  • For matching exact values to conditionally format, do something like =EXACT(A1;"Foo")

Comments