Ask Your Question

Conditional formatting with different cells [closed]

asked 2017-05-02 18:19:54 +0100

MG312 gravatar image

updated 2017-05-02 18:25:49 +0100


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:

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-10-03 16:00:52.558660

1 Answer

Sort by » oldest newest most voted

answered 2017-05-06 23:30:56 +0100

erAck gravatar image

updated 2017-05-06 23:39:26 +0100

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")),"")

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-05-02 18:19:54 +0100

Seen: 61 times

Last updated: May 06 '17