Search code examples
google-sheetsgoogle-sheets-formulaopenoffice-calcautoformatting

Conditional cell formatting


Is it possible to autoformat spreadsheet like this

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


Solution

  • 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