I regularly use Ctrl+downarrow to move to the next cell containing a value in columns in Calc.
I made a diary recently.
I used conditional formatting to highlight the current day in red, as shown in the lower image. Lovely.
I’d like to use Ctrl+downarrow to move to the current day, but of course I can’t because all the cells in that column (C) contain formulas and resultant values.
So, I made a formula that shows TX in column A if the value of the adjacent cell C == C1. You can see, for example, that C70 == C1 in the images. Again, just what I wanted.
When the sheet opened I tried using Ctrl+downarrow (in column A) to jump to A70 (the current day and the only cell showing TX).
The problem is that Ctrl+downarrow not only jumps to cells with displayed values, but also to cells containing formulas even though such cells aren’t displaying any values.
Effectively, it moves down to the last cell in column A containing a formula (A365 in this sheet) rather than to the next cell displaying a value (TX). Not what I wanted.
I’d like to find, or create, a key combination that moves to the next cell with a displayed value in column A and doesn’t include cells that display nothing but which contain formulas.
C1 contains =TODAY()
C2 contains 01/01/2018
C3 contains =C2+1 The remaining cells in column C continue to reference the cells above them.
A70 (and all the cells above and below it) contains =IF(C70=C$1,“TX”,"")
(The numbers in column B are just the manually entered week numbers, in case anyone was wondering)
Thanks in advance for any help offered.