Depending on previous values

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,
there is a column which has an entry of 0 or 1 depending on the product delivary, if consecutivly there is no delivary for more than two days I need to change the colour of the cell, could any body help me on this as i am manually changing them now.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
802
use conditional format
select first data for e.g. it is A2
click format menu-conditional formatting
there are three windows
in the first window
"the cell value is "
the second window is
equal to (choose from the donwload llisst)
the third window
=A1(equal to sign necessary
click format in the middle
in the format window
choose "font" in the top window (if you want you can experiment with choosing pattern)
click the arrow in the "color" arrow
choose any color
clcik ok
again back to confditional formatting window
click here alao ok

select A2
edit-copy
select A3 to down
edit-pastespeial-format(4th item under "paste"
click ok

Hope I have not missed any step
confirm