Column wise condition formating

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
I HAVE A ATTENEDANCE TABLE LIKE THIS
NAME 01 02 03 04 05 06 07 08 09 10 UPTO 31
M T W T F S S M T W LIKETHIS

ARUN
SATHIYAN
RAJAN
GULAM


IN THE ABOVE TABLE I NEED HIGHLIGHTED UNDER SUN AND SAT IN DIFFERENT COL PLS HELP

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
804
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 .
0