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)
Excel.jpg
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?
It's little wordy now, but what I'm trying to accomplish here is that I want make values change their color based on previous data on the row (I belive i've done that) while skipping blank cells and find the previous data on the same row. (Some of the data are shown green even though there aren't any data in the front)
If my question is too confusing, let me know. I can answer any questions you guys might have.
Thank you guys.
Bookmarks