Excel2010 Coditional formatting Issue

[green4000]

Hi, guys

I ran into a problem while I'm creating daily work out data.
Basically I have all data in number values.
Each column is labeled with current date like C4 is 7/1, D4 is 7/2, E4 is 7/3 and so on.
And I started inputting how much I lift that day ( C5 is 155 (lb), D5 is 165, E5 is 145 and so on)
Some days I lift heavier weights than last time, but some days I lift lighter weights.
I was using conditional formatting to show my performance by changing font color to green when I lift more weight, to red when I lift less weight, and no changes when I lift same weight from previous)

I created 3 different conditional formatting --> Use a formula to determine which cells to format
=D5>C5 (changed font color to green)
=D5<C5 (Changed font color to red)
=D5=C5 (no change on format)

Then I used format painter to copy all other cells.
It worked out somehow, but I ran into a problem.
I skipped few days between workout days. I worked out on 7/1,2,3 and skipped 4,5 and came back working out 7/6)
Because I skipped few days, 7/6 data shows in green color even though I lift less than 7/3.
What formula can I add to have the cell look 7/3 data when there is no data in 4th or 5th?

If my question is too confusing, let me know. I can answer any questions you guys might have.

Thank you guys.

[shukla.ankur281190]

If you can share your XL sheet... We'll be much able to answer you fast...

[JeteMc]

It would be great if you could re-title your post so as to describe the problem, perhaps "Conditionally formatting value changes in a row".
Given your description of the problem I think this will do what you want. I added a helper row with the formula

Please Login or Register  to view this content.

I then reset your conditional formatting rules to read

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

The added row could be grouped and hidden. Here is a sample file with the formula and rules applied:

Conditionally formatting value changes in a row.xlsx