Highlighting a Weight Value That Is Below a Goal Weight
In the screenshot below (in my comment to this post), you can see where I've been manually highlighting the daily Pounds value that is less than the upcoming Goal value. For the life of me, I can't figure out the formula to automate this conditional formatting.
Posted Apr 27, 2023, 4:29 PM UTC · edited
https://preview.redd.it/2n04e82cwhwa1.png?width=443&format=png&auto=webp&v=enabled&s=a6ec3ab481f579325d18b38d83666da65fbeb7b0
The simplest would be to put the goal weight in every cell in column C, e.g. 230 for 3/27 to 3/30, 229 for 4/2 to 4/7, etc. and then apply the conditional formatting custom formula
=D2<C2to the range D2:D.If you want to maintain the current look of the table, you could add another conditional formatting custom formula
=C2=C3to the range C2:C in order to change the font color to white.I don't want to put values in column C because I'm creating a "goal line" with those values in an associated chart:
https://preview.redd.it/8kcwbhm1uowa1.png?width=362&format=png&auto=webp&v=enabled&s=10d9518ac703aee6c963cd86bbaffd2f3785758b
You could always use a different column for the chart, although it sounds like the point is moot in this case.
BTW, instead of "Accepted as sօlution", you should reply to awwsheets' post with
Solution Vеrifiеdin order to award them a ClippyPoint. A bot assigns the points, so the wording needs to be exact.[deleted]