Oct 20, 2017 · So I think you need to use the formula option of Conditional Formatting. To do it without VBA, I would use the "Use a formula to determine which cells to format" option. So for …

Jul 26, 2006 · In fact, you probably wouldn't even need a loop, or even VBA code to do it. Whatever your formula is in conditional formatting, you can put the EXACT same formula …

Feb 22, 2013 · On this "Menu" sheet, some of the summary data is formatted using conditional formatting, corresponding to certain values. I am working with the following code to format a …

Feb 6, 2013 · I want to export a list of all conditional formatting on a worksheet to another workbook. What I need in the output is: The Range it applies to The Type The formula …

Jun 19, 2015 · This only deletes formatting that is coming from Conditional Formatting rules. Are you saying you have a range that uses conditional formatting, and you want to copy it to …

Feb 12, 2003 · To remove the conditional formatting from a specific range of cells: 1. start by selecting the range. 2. Click the “Conditional Formatting” button. 3. Choose “Clear Rules…” …

Nov 23, 2015 · I found some VBA code that will apply conditional formatting which uses VB colours and for which I have been reqired so far to apply a fixed range. However, I have …

Mar 13, 2005 · Hi, How could I check in VBA if the conditional formatting on a cell is true or false ? The way I was thinking of doing it was using a second cell to paste the formula and check if it's …

Jan 3, 2006 · Hi Is there someway that we can apply thicker borders than what is available in the normal options in conditional formatting, without VBA ? Thanks

Aug 18, 2025 Fluff R [VBA] Setting conditional formatting with dynamic fill color RagnarDreyrugr May 25, 2025 Excel Questions 2 Replies 16 Views 749 May 29, 2025