Spreadsheet: 192350d1352386508-change-the-font-color-in-a-exel-sheet-attendance-1-
Sheet: Sheet1

 | Sr. | Name | Emp Code | DOJ | Designation | Department | ATTEDENCE SHEET FOR THE MONTH OF JANUARY 0000
 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | P | L | A / LWP | S.Day / H.Day | L Adj. and Pay days
 | 1 | A | 1 | 00-00-00 | XYZ | XYZ | P | L | X | S | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0 |  |  | P
 | 2 | B | 2 | 00-00-01 | XYZ | XYZ | X | L | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0 |  |  | L
 | 3 | C | 3 | 00-00-02 | XYZ | XYZ | X | H | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0 |  |  | S
 | 4 | D | 4 | 00-00-03 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0 |  |  | H
 | 5 | E | 5 | 00-00-04 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0 |  |  | A
 | 6 | F | 6 | 00-00-05 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0 |  |  | HL
 | 7 | A | 7 | 00-00-06 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0 |  |  | X
 | 8 | B | 8 | 00-00-07 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0
 | 9 | C | 9 | 00-00-08 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0
 | 10 | D | 10 | 00-00-09 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0
 | 11 | E | 11 | 00-00-10 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0
 | 12 | F | 12 | 00-00-11 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0
 | 13 | A | 13 | 00-00-12 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0
 | 14 | B | 14 | 00-00-13 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0
 | 15 | C | 15 | 00-00-14 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0
 | 16 | D | 16 | 00-00-15 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0
 | 17 | E | 17 | 00-00-16 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0
 | 18 | F | 18 | 00-00-17 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0
 | 19 | A | 19 | 00-00-18 | XYZ | XYZ | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X |  |  |  |  | 0
 | Row H9 to M9
 | Here I want whenever I fill the attendance sheet I want the color of fornt to be change to RED except for P