Apr 16, 2025 · Hello guru’s. I need help solving this issue here. I am looking to find a formula or conditional formatting to solve my problem. Each row represents a sales order. Column A are …

Oct 22, 2023 · Excel number formatting for formulas I have copy pasted some data (numbers) into an excel document but when I try to use them in a formula (e.g. SUM) it always just gives me …

Jul 3, 2025 · When viewed in Excel it shows like this, 2.68435E+17 The only way I can get Excel to display the number even close is to format it as text. I need to upload this data into another …

Jun 3, 2022 · I want to use a custom number format that changes the format based the size of the value in the cell. For example for positive #s : [<1]#0.000 [<0.1]#0.0000 [<0.01]#0.00000 …

Mar 7, 2024 · How to do conditional formatting with SORT function? HI, I got this list that i sort. it has two columns, one column is names and on coulmn is numbers, and when the number in …

Feb 19, 2013 · My modifications and additions format phone numbers to: xxx-xxx-xxx, but the code can easily be tweaked to give you what you want. One note, Outlook likes to auto-format …

Nov 24, 2024 · Hi,Is there a way of easily copying and pasting conditional formatting without duplicating and then editing the formula each time?Thank you in advance for your help.

May 20, 2010 · There is no Format tab per se. You have formatting options on the Home tab. And you have a Font dialog box by clicking the quick launch button in the bottom right corner of the …

Mar 29, 2022 · Hi, How to use VBA to create and remove conditional formatting at once click? My excel files is similar to the sample file - Dependent Data Validation Advanced (source: …

Sep 9, 2020 · Copy conditional formatting from one worksheet to another I'm working on a big project in which I have created a "master" excel template for my users to copy and use for …