Jul 05 2022 01:23 AM
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?
Jul 05 2022 04:25 AM
Jul 10 2022 01:47 PM - edited Jul 10 2022 02:15 PM
Thanks, but not using Macros and no conditional formatting on the "This Worksheet" selection.
Jul 10 2022 07:17 PM
Jul 11 2022 07:04 AM
Jul 11 2022 07:08 AM
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.
Jul 11 2022 07:17 AM
I think I found the solution
It is in the Excel Options > Advanced > Extend data range formats and formulas
Thanks for trying to help
Jul 11 2022 07:19 AM