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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 17, 2009 at 08:30 PM
Related:
- Depending on previous values
- How to see previous downloads on safari - Guide
- When you add someone to close friends can they see previous stories - Instagram Forum
- Some of your previous comment didn't follow - Facebook Forum
- 4 of your comments go against our standards on spam ✓ - Facebook Forum
- Review requested If we find that your posts or comments didn - Facebook Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Dec 17, 2009 at 08:30 PM
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
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
