Forum Discussion

SantaMills's avatar
SantaMills
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?

  • mtarler's avatar
    mtarler
    Silver Contributor
    It is possible it is from a macro but are you sure there isn't conditional formatting? When you go into conditional formatting window it defaults to only show 'this selection' and try using that drop down and show entire sheet.
    • SantaMills's avatar
      SantaMills
      Copper Contributor

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

       

      • mtarler's avatar
        mtarler
        Silver Contributor
        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?

Resources