Conditional Formatting and an IF statement - MrExcel
May 1, 2007 · I need to know if it's possible to make Excel use an IF statement to decide whether to apply conditional formatting to a cell. What I have is this: If cell G2 is greater than or equal …
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 …
If statement for detecting true/false conditional formatting
May 26, 2004 · Good morning all. I need to write an If-Then statement in one of my macros that has to detect whether or not a conditional format for a specific cell is active or not. If the …
Apply a preset style using Conditional Formatting? - MrExcel
Jun 23, 2015 · Chrisdontm, thanks for the reply! I don't think I was clear enough initially - I want to have Conditional Formatting apply a preset style to a cell based on a formula result.
Conditional Formatting IF Statement for Odd/Even - MrExcel
Aug 29, 2012 · I am trying to write a conditional formatting with an if statement I have 2 rows of numbers (Row 1 Col A-Q and Row 2 A-Q) I have a 3rd row (Row 4) with odd/even numbers. …
Conditional Formatting with If statement not working
Jan 28, 2020 · Hi Everyone, I pretested this on my sheet to show for true DC and false STORE but when I try to use it for conditional formatting it doesn't work. =IF(AND(C23,B2>800),"DC", …
conditional formatting icon, use in if statement - MrExcel
Mar 24, 2022 · Hello! I have a a big dataset where I've used the conditional formating to color values that are grouped as: The values are in percentage of the total in that specific dataset, …
[VBA] Setting conditional formatting with dynamic fill color
May 25, 2025 · In your original post you asked for conditional formatting of column P based on what is in Column O. If you were doing conditional formatting manually of column P based on …
VBA Apply Conditional Formatting Formula If Cell Contains...
Dec 31, 2014 · I have some previously existing code that works fine, but I think I need to add either an "if" statement or an "and" statement to the formula somehow. I have a report that is …
Conditional Formatting to Ignore Formula - MrExcel
Aug 29, 2012 · When the IF statement returns "" the cell in blank. I want to highlight the cells that are greater than zero in conditional formatting but when I set that parameter the blank cells …