About 57,300 results
Open links in new tab
  1. Excel: How Can I Copy Cell Formatting? - Excel Tips - MrExcel …

    Aug 6, 2025 · I have a series of identically shaped regions. I’ve formatted the first report and want to copy the formatting to the other reports.

  2. How to apply cell formating without having to double click each …

    Jul 1, 2020 · When i select the column and change the cell formate to the desired date model, it doesn't do anything at all, when i then double click any cell, it changes instantly to the desired …

  3. Conditional Format cells for Zero AND Not Blank - MrExcel

    Jan 3, 2019 · I have three conditional format rules. 1. Yellow for cells that are greater than 0 - using...Cell value >0 2. No formatting if blank -...

  4. One cell's formatting mirrors another | MrExcel Message Board

    Jan 28, 2014 · In cell A1 i have a drop down list with conditional formatting in place. Depending on the value i select, the cell A1 will change fill color. I want cell B1 to change fill color to match …

  5. Replace Destroys Formatting - Excel Tips - MrExcel Publishing

    Oct 23, 2017 · Using Find and Replace will screw up your in-cell formatting. What do I mean by that? Let's say that you have 25 letters in Excel and only the third word is bold or red. Find and …

  6. Linking cells and keeping formatting | MrExcel Message Board

    Apr 1, 2004 · Formatting only: Pastes only the formatting, leaving all values and formulas out of the pasted range. Link cells: Links the pasted cells to their original location.

  7. Apply a preset style using Conditional Formatting? - MrExcel

    Jun 23, 2015 · (Using Excel 2010) With Conditional Formatting, if I use a formula to define which cells to format, how can I have the result be formatted per one of the...

  8. Change cell color not using conditional formatting - MrExcel

    Jan 25, 2016 · Hi all, Is it possible to use a function (if statement or an array?) to change the color of a cell without using conditional formatting. I don't want to use conditional formatting because …

  9. Mysteriously Disappearing Cell Formatting - MrExcel

    Dec 21, 2016 · Hello - Recently, Excel 2016 has been acting strangely. At work, I use many spreadsheets (.xlsx and .xlsm) that I often color code cell contents with various font colors and …

  10. Insert text in cell based on conditional format? - MrExcel

    Aug 11, 2017 · I'm new to Excel and use Mac Excel 2011. I understand the basics of conditional formatting but I can't quite figure out how to enter text in one cell based on whether another …