Im trying to do a formula to separate in the same column any cell with colored data.
Col A has Name of person
Col B-H has times i.e. 0800-1630 or 0600-0230
Cell B50 has formula =counta(b1:b49)
Cell B51 has formula =counta(b1:b49,"=off")
How would I separate any times that are in the color font blue from the black font.
Lets say col. B1-B20, B41, B44,45,46 have times in black font and B21-B40,42,43,47,48,49 are in blue font. What formula or macro should be used?
Any ideas?
Col A has Name of person
Col B-H has times i.e. 0800-1630 or 0600-0230
Cell B50 has formula =counta(b1:b49)
Cell B51 has formula =counta(b1:b49,"=off")
How would I separate any times that are in the color font blue from the black font.
Lets say col. B1-B20, B41, B44,45,46 have times in black font and B21-B40,42,43,47,48,49 are in blue font. What formula or macro should be used?
Any ideas?