Previous Topic Next Topic

Depending on previous values

Closed
saj - Dec 17, 2009 at 08:14 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 17, 2009 at 08:30 PM
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 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 17, 2009 at 08:30 PM
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
0

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
SATA Drive not detected while installing XP
bahurdeen -
Dave -

31 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response
two values to find on the same cell
jutulu -
jutulu -

2 responses
Your comment goes against our Community Standards on spam
9825713374 -
HelpiOS -

1 response