Nested IF result colors with Conditional formatting - Excel Help Forum Re: Nested IF result colors with Conditional formatting Hello and welcome to the forum With conditional formatting, you have to create one rule per fill color For this example, you will have to create 4 rules Let's say that the range of cells that you would like to conditionally format is A2:A10 (and that the numbers are also in A2:A10)
Change cell color using if statement, NOT conditional formatting Re: Change cell color using if statement, NOT conditional formatting Hi, Not without incorporating a macro to react to the change event and then colour the cells But surely that's the sledgehammer to crack the proverbial nut What's wrong with a conditional format? That's exactly what it's meant for
If (and Statement in Conditional formatting - MrExcel Can someone please help me write the correct syntax for an "If(and" statement for conditional formatting I am trying to highlight cell B1 in Yellow if the value in cell A1 = "Business" and B2 = Blank This is the syntax I am using keep my curser in Cell B1
Conditional Formatting with If statement not working 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", "STORE") I have it selected for the entire B:C columns Just want it to highlight if anything in the C column and B
Clear cell contents if Conditional Formatting is applied to it FormatCondition = True? Hi, I'm trying to use a macro to delete a cell if it IS conditional formatted It seems right now that the colorvalue of the font is NOT stored in Font ColorIndex, and so my IF statement based on that is not working either Here's the statement I am trying to use: Public Sub
Conditional Formatting and an IF statement - MrExcel 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 to 15 then cell D2 should have no conditional formatting applied to it, cell should have no fill If cell G2
Conditional formatting for blank cells containing formulas? I want to create a conditional formatting for this row, so whenever a value is entered, it gets highlighted in a certain color However, whenever I try this, it highlights all the cells, because they contain this formula (even though the formula returns a blank value, as seen in column G, H and I above for example
Conditional Formatting with If Statement - Excel Help Forum Conditional Formatting with If Statement I have a spreadsheet with budget figures and I am trying to use conditional formatting to show increases from one month to another by a certain percentage Cell H26 has a July amount Cell I26 has a Aug amount