Greetings All,

I regularly use **Ctrl+downarrow** to find next values in columns in Calc.

I made a diary recently.

I used conditional formatting to highlight the current day in red, as shown in Image 2. 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** jumps not only 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 with a formula (A365 in this sheet) rather than to the next displayed value (TX). Not what I wanted.

*I'd like to find, or create, a key combination that finds only the next cell with a displayed value in column A and doesn't include cells that display nothing but which contain formulas.*

Here's what's in my cells:

**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.