Forum Discussion
Conditional Format Formula
SahuaroCon wouldn't it be easier to just add a column "Time Left" and do the conditional formatting on that? Then you see the remaining hours and you can easily use some nifty built in conditional formatting rules like "Format all cells based on their values" and you can do 2 or 3 color gradients, data bars that fill the cell like a fuel gauge, or icon sets.
xspJodymaybe I'm missing something but wouldn't you formulas be easier if you just used the '$' to lock the column i.e. =($E3=0)
"Absolutely. The reason I presented the solution as I did though is because the user did not have a column for this value. Since I have no way of knowing the full nature behind someones questions I try to present solutions that fit their style as much as I can."
"It may as well still be easier to add a column for this data and refer to it in their conditions as opposed to using the OFFSET function."