Nov 8, 2022 · I have a spread sheet, where column A is SKU Numbers, and Column B is quantity in stock. I've found a formula for conditional formatting so cells in column B are highlighted …

Nov 29, 2022 · I have specific cells that I want to automatically appear with the text 'VACANT' if the manually entered data is removed. I have been unable to find how to do that on my own. …

Sep 27, 2024 · In conditional formatting, how do I identify cells that are blank to contain a specific formatting, i.e. I want to highlight all blank cells in a column?

May 22, 2023 · I have looked at conditional formatting based on date and can work out how to highlight (change cell colour) if date is in a specific category (yesterday, last week, last month, …

Feb 15, 2021 · Excel Conditional Formatting with formula that will copy paste down and over I can do very basic CF, but I completely trip up when I want to create one that will copy paste …

Mar 7, 2024 · A and B have conditional formatting (B is numbers and if they are negative then they turn red, and A has condition that say that if B1 is negative then A1 will be red), and then …

Jul 10, 2025 · I have a question...I have a data validation list that contains 4 choices for entry and they are all text. I know that you can only have 3 conditional format rules per cell in Excel …

Aug 5, 2012 · Excel 2010 Conditional Formatting To Compare Values In 2 Other Cells I’m trying to use a formula in conditional formatting to make a cell (O8) change its fill colour when: The …

Feb 10, 2015 · Protect Conditional Formatting with Data Entry I want to allow user data entry into a cell and protect the conditional formatting (CF) in that cell. The CF is removed by Pasting to …

Jun 22, 2012 · Using icon sets for conditional formatting based on formulas Hi there, I am currently using conditional formatting based on formulas in a spreadsheet and have managed …