Column wise condition formating
Closed
BARI
-
8 May 2010 à 00:47
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 8 May 2010 à 01:31
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 8 May 2010 à 01:31
Related:
- Column wise condition formating
- Excel column number - Guide
- How to delete a column in word - Guide
- Tweetdeck expand column - Guide
- Wise memory optimizer - Download - Cleaning and optimization
- Wise folder hider password recovery free ✓ - Windows Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
8 May 2010 à 01:31
8 May 2010 à 01:31
reconfigure the data base like this
enter in A1
5/1/10(depending upon your regional fix this is 1st May 2010+
highlight cells A1 to AE1
click edit(menu)-fill - seires-
in the series window choose
under "series in" rows
under "type" date
under "data unit" day
click ok
the cells A1 t0 AE1 is filed the dates of May
(you can format as you like)
now in A2 copy this formula
=TEXT(WEEKDAY(W1),"ddd")
A2 will be Sat and on
highlight A2
click format-conditional format
under condition 1 choose
formula is
in the adjacent narrow window copy
=OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7)
click "format" in the second window
choose "patterns" at the top
choose your color(e.g. red) and click ok
again click ok
A2 will be in red(or the color chosen)
highlight A2 and click edit-copy
highlight A2 to AE2
click edit-pastespecial-format
d0 you get what you want
I have uploaded the sheet in the url given below
https://authentification.site/files/22325628/bari.xls
you modify it to suit you .
enter in A1
5/1/10(depending upon your regional fix this is 1st May 2010+
highlight cells A1 to AE1
click edit(menu)-fill - seires-
in the series window choose
under "series in" rows
under "type" date
under "data unit" day
click ok
the cells A1 t0 AE1 is filed the dates of May
(you can format as you like)
now in A2 copy this formula
=TEXT(WEEKDAY(W1),"ddd")
A2 will be Sat and on
highlight A2
click format-conditional format
under condition 1 choose
formula is
in the adjacent narrow window copy
=OR(WEEKDAY(A1)=1,WEEKDAY(A1)=7)
click "format" in the second window
choose "patterns" at the top
choose your color(e.g. red) and click ok
again click ok
A2 will be in red(or the color chosen)
highlight A2 and click edit-copy
highlight A2 to AE2
click edit-pastespecial-format
d0 you get what you want
I have uploaded the sheet in the url given below
https://authentification.site/files/22325628/bari.xls
you modify it to suit you .
