Forum Discussion

Copper Contributor

Jul 05, 2022

Excel Formats my values without conditional formatting

I have a spreadsheet. When I enter values, the color of the cell turns green. There is no conditional formatting. Where does the formatting come from?

excel

Formulas and Functions

SantaMills

Copper Contributor

Jul 10, 2022

Thanks, but not using Macros and no conditional formatting on the "This Worksheet" selection.

mtarler

Silver Contributor

Jul 11, 2022

so the file is a .xlsx (not .xlsb or .xlsm)?
also can you clear the formatting?
and are you on desktop or in the web version? mac or pc? what version?

SantaMills
Copper Contributor
Jul 11, 2022
- It is .xlm but no Macros
- I saved it as .xlsx - same problem
- If I clear the formatting on .xlsm (also .xlsx) then the automatic formatting does not happen with new data entered
- I would still like some fields to be formatted, but not by default
- HansVogelaar
  MVP
  Jul 11, 2022
  SantaMills
  
  Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
  - SantaMills
    Copper Contributor
    Jul 11, 2022
    HansVogelaar mtarler
    
    I think I found the solution
    It is in the Excel Options > Advanced > Extend data range formats and formulas
    
    Thanks for trying to help