Conditional Formatting

[mang121]

I have a sheet with a couple hundred rows of data. I want to format the font in G5 to be red if the value is less than D5. This part I have figured out. What I cannot figure out is how to apply this formula to G6, G7, G8,etc... and their corresponding D6,D7, D8, etc... quickly. I am manually setting up each rule in each cell.

I've tried absolute referencing in the conditional formatting formula but with no luck.

 

[Joe4]

Select all the cells you want to apply the Conditional Formatting to, and then write the CF formula as it applies to the first cell in your selection.
For example, if you wanted to apply it to G5:G100, select range G5:G100 and enter the CF formula:

=$G5 < $D5

and choose your formatting color.
Excel will automatically adjust it for all the other rows in your selection.

 

[mang121]

Perfect. Thank you!

 

[Joe4]

You are welcome!