Conditional Formatting

[frustrated_macro]

Hi
I have dates in two diff columns, and need to highlight when the date in J is bigger than the one in D, of that same row
And i can get the conditional formatting to work on that one row, but how do i apply it to allll rows of the document, so that its alwasys looking at the matching row
so like J22 and D22 are compared and not D22 vs J12
The second picture is whats happening when i try to apply it to the whole column

 

[Fluff]

What formula are you using?

 

[Joe4]

Select JUST the range you want to apply the Conditional Formatting to, i.e. J3:J100 or whatever row you want to go down to.

Then, write the Conditional Formatting formula as it applies to the FIRST cell in that range, and it will adjust it for the others, i.e.

=AND(J3>D3,J3>0,D3>0)

and choose your desired formatting option.

 

[frustrated_macro]

Select JUST the range you want to apply the Conditional Formatting to, i.e. J3:J100 or whatever row you want to go down to.

Then, write the Conditional Formatting formula as it applies to the FIRST cell in that range, and it will adjust it for the others, i.e.

=AND(J3>D3,J3>0,D3>0)

and choose your desired formatting option.

perfect! thank you lots!

 

[Joe4]

You are welcome.
Glad we were able to help!

 

[frustrated_macro]

You are welcome.
Glad we were able to help!

me again
i have a new set of data where i COULD have a blank on either column im looking at so the J>0 D>0 wont work

 

[frustrated_macro]

me again
i have a new set of data where i COULD have a blank on either column im looking at so the J>0 D>0 wont work

nevermindddd, got around it!

 

[frustrated_macro]

okay, new issue
i need to create a macro that basically does this kind of conditional formatting

the range will be G2:G & LAstRow, which has already been defined, the range in the screenshot was just me testing that all the colors worked
but i have no idea how to write that into the macro. i had a very sad attempt at an IF loop, but im not sure how to properly write the formula AND the formatting into the loop.

 

[Joe4]

okay, new issue
i need to create a macro that basically does this kind of conditional formatting

View attachment 108834


the range will be G2:G & LAstRow, which has already been defined, the range in the screenshot was just me testing that all the colors worked
but i have no idea how to write that into the macro. i had a very sad attempt at an IF loop, but im not sure how to properly write the formula AND the formatting into the loop.

As that is an entirely new question with new requirements (looking for VBA code instead of Conditional Formatting), you should post it to a brand new question so it appears in the "Unanswered threads" listing.