Condtionally format an entire row based on adjacent cell values

[Martinp217]

Hello,

I've been scratching my head at work on this one for over an hour...I have read numerous threads, tried about 20 different formats/formulas, and nothing has worked yet.

I have a large workbook with 2 rows of data I want to format (R25:R530, M25:M530). Row M is already populated, row R is new data that I am entering. When the value of a cell in row R is larger than its adjacent cell (R25:M25) in row M, I would like the font to turn red. When the value is smaller, I would like the font to turn green.

Any help would be greatly appreciated...with the amount of time I've spent attempting to conditionally format, I could have gone through and formatted each cell individually by now!

[weeble33]

Sounds easy enough, can you post the workbook, or part of it?

[Martinp217]

Attachment 238178Sure. Here is a portion of the workbook.

[weeble33]

Here's a quick mock up, will this work?

[weeble33]

Did you want both R and M to turn red? or just R or just M?

[Martinp217]

Just R. Thanks, your example book looks helpful...I had been doing an absolute reference on the row.

[weeble33]

K, here you go...yea I imagine it was the absolute reference that you weren't changing. And there is no condition setup for equal values, so maybe you wanna change to less than or equal is green or whatever an equal value would be

[Martinp217]

Wow...I can't believe it was that simple. Thank you very much!

Martin

[Martinp217]

]]]]]]]]]]]