I am trying to apply a new conditional formatting rule and it is not working

[Derquila]

Hello and let me apologize up front for this question.

I am trying to apply a new conditional formatting rule and it is not working

The rule is simple but it seeems to be formatting randomly. There are no other rules in the workbook. Column C is =B1>A1 etc.
Format where true =$B1>$A1
Apply to =$B$1:$B$19

 

[Derquila]

The green fill is the format when the condition is met

 

[Peter_SSs]

We cannot see your row numbers but it looks like you might have had the wrong cells selected when you applied the CF formula or else the CF formula is incorrect for the cells selected.

Can you give us the sample data with XL2BB?

 

[Derquila]

Hi. Column C is not part of the conditional formatting. It was included to illustrate the difference between a statement [Column C =B1>A1] which is working correctly and how the conditional formatting is handling the same statement incorrectly. I do not have access to the file at the moment but will return tomorrow or soon after. Thank you.

 

[Peter_SSs]

Given some of the column C results in post 1, I am assuming that column B contains formulas so the cells that appear blank are not actually empty but contain a formula result of ""
If that is so, then I don't see how the formula in column C gives any different result to Conditional Formatting with the same formula .. unless, as I said before

you might have had the wrong cells selected when you applied the CF formula or else the CF formula is incorrect for the cells selected.

I am also swayed about wrong selection and/or wrong CF formula because you mentioned in post 1 about applying this CF to B1:B19 but your image only shows 18 rows.

Here is my sheet with column C formula the same as he formula in the CF

24 02 05.xlsm
	A	B	C
1	202401	202402	TRUE
2	202401	202401	FALSE
3	202401	202402	TRUE
4	202401	202401	FALSE
5			FALSE
6	202402		TRUE
7	202402		TRUE
8	202402	202402	FALSE
9	202402	202402	FALSE
10	202402	202402	FALSE
11			FALSE
12	202403	0	FALSE
13	202403	0	FALSE
14	202403	0	FALSE
15	202403	202403	FALSE
16	202403	202404	TRUE
17	202403	202404	TRUE
18	202403	202403	FALSE
CF

Cell Formulas
Range	Formula
C1:C18	C1	=$B1>$A1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B1:B18	Expression	=$B1>$A1	text	NO

 

[Derquila]

Unfortunately my IT it appears will not allow XL2BB to run (may need to restart). Here is an image of what I am seeing. Thank you.

 

[dreid1011]

As Peter mentioned already, it looks like your selected range does not match up with the CF formula. You have selected A1 as the top of your range, but your CF formula starts at B2... so your highlights are not going to be accurate. Either keep the same selected range and change the formula to =$B1>$$A1, or change your selected range to start at A2 and keep the same CF formula.

 

[Peter_SSs]

Here is an image of what I am seeing.

That confirms what I was getting at before. In that image, cell A1 is the active cell but the formula refers to row 2 cells.

it looks like you might have had the wrong cells selected when you applied the CF formula or else the CF formula is incorrect for the cells selected.

With both columns selected and A1 as the active cell, go back in to that conditional formatting dialog, click on the rule then Edit Rule and change the formula to =$B1>$A1

 

[Derquila]

Thank you, understand the issue. I did not realize we must set the application range to the location of condition statement.

 

[Joe4]

You just need to write your CF formula as it applies to the very first cell in the range you are applying it to, and then Excel will adjust the formula for all the other cells (depending on how you have set the range references, to be absolute, relative, or a mixture).

Since you have selected to apply it to all of columns A and B, your first cell in that range is cell A1.
If you don't want the Conditional Formatting to apply to row one, then don't select the entire column as the range to apply it to.
Start in cell A2 and go down as far as you want/need in column B.