Conditional formatting with different cells

[MG312]

Hi,

I am modifying our daily till reconciliation sheet to clearly show whether our till is up or down. This has become necessary due to errors being made…

I’ve worked out how to show this, but as you can see it then shows the rest of the week as Till Down in row 17 (or to be pedantic the rest of the week would show the most recent days resulting discrepancy). What I am aiming for is row 17 not to show anything until the till values are entered for that day.

My formula for row 17 cells is =IF(C16<0,“Till DOWN”,IF(C16>0,“Till UP”))

(Row 11 brings forward the previous days float figure to help eliminate input errors)

Is there a way to do this? I would be very grateful for any help offered.

Hopefully you can find a link to an image of my spreadsheet here: https://s5.postimg.org/55inmn2qv/Libre_Office_daily_till_reconciliation_help.jpg

[erAck]

You seem to want to also test if the corresponding cell in row 15 contains a value, so your formula should be =IF(ISBLANK(C15),"",IF(C16<0,"Till DOWN",IF(C16>0,"Till UP","OK")))
Note I also added an “OK” there as the last else path, otherwise if the result in C16 was 0 a FALSE would be displayed.

If cells in row 15 contain a formula (obviously not identifiable in that image) then instead it should be something like =IF(C15,IF(C16<0,"Till DOWN",IF(C16>0,"Till UP","OK")),"")