Column wise condition formating
Closed
BARI
-
May 8, 2010 at 12:47 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 8, 2010 at 01:31 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - May 8, 2010 at 01:31 AM
Related:
- Column wise condition formating
- School time table class wise and teacher wise software free - Download - Organisation and teamwork
- Wise memory optimizer - Download - Cleaning and optimization
- Wise data recovery - Download - Backup and recovery
- Available memory less than 15mb condition zero - Guide
- How to convert row to column in notepad++ ✓ - Excel Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
May 8, 2010 at 01:31 AM
May 8, 2010 at 01:31 AM
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 .
