conditional formating formula question

[biglb79]

is there a formula I could use that would highlight cells AB3 and and AC3 in green if all cells G3:AA3 have been initialed and dated? I don't know the exact length for both. someone could use BB 10/28 or BBB 10/28/20

2nd part of formula would be to have them highlighted in red if there isn't an initial and date? currently names are listed and everyone is replacing their name with initials and date once completed so it can't just be any type of fill in the cell. hopefully my question makes sense. thanks in advance!

 

[etaf]

G3 to AA3
are those cells blank initially and then populate

currently names are listed and everyone is replacing their name with initials and date

where are the names listed
when they enter 10/28 - is that actually in excel as a date or text
perhaps a small example of say 4 cells
G3, H3, I3 and J3

 

[biglb79]

G3 to AA3
are those cells blank initially and then populate

where are the names listed
when they enter 10/28 - is that actually in excel as a date or text
perhaps a small example of say 4 cells
G3, H3, I3 and J3

names are listed in every cell from G3:AA3. it lists everyone that is assigned to each task, and then they are supposed to do the task in AB and AC once G:AA have been completed. I thought it may be easy if those cells highlight once names are deleted and replaced with initials and dates.

 

[etaf]

so John Smith , will be replaced with JS 10/01/20 or JS 10/1/2020 or JS 10/01 or JS 10-1-20 or JS 10/1 or any other possible date format in the one cell

John Edward Smith = JES
John Harvey-Smith = JHS
John Edward william Henry Smith = JEWHS

would they use the middle name(s)

 

[biglb79]

so John Smith , will be replaced with JS 10/01/20 or JS 10/1/2020 or JS 10/01 or JS 10-1-20 or JS 10/1 or any other possible date format in the one cell

John Edward Smith = JES
John Harvey-Smith = JHS

basically but it's mostly just first names in the cells now so like Bill would be BB 10/28, Brian would be BM 10/28, Erica would be ES 10/28 and there are others

 

[etaf]

so none of the cells now would have a space in the text but the new entries all would have a space

 

[biglb79]

so none of the cells now would have a space in the text but the new entries all would have a space

pretty much but now that I look at it there is a Cindy T and Cindy M. I could possibly just change those to CindyT and CindyM

 

[biglb79]

but none of the cells will contain a number until completed

 

[etaf]

Very messy , must be a better way

=SUMPRODUCT(LEN(G3:AA3)-LEN(SUBSTITUTE(G3:AA3," ","")))=21
as a formula in the conditional format for green

=SUMPRODUCT(LEN(G3:AA3)-LEN(SUBSTITUTE(G3:AA3," ","")))<>21
for RED

OR
=COUNTIF($G$3:$AA$3,"*/*")=21

 

[etaf]

for ease I have just used 5 columns rather than 21

Book1
	F	G	H	I	J	K	L	M	N
1		G3 to AA3						AB3	AC3
2		fred	****	harry t	bb 10/28	cc 10/28
3		bb 10/28	cc 10/28	bb 10/29	cc 10/29	bb 10/30
4
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
M2:M3	Expression	=COUNTIF(G3:AA3,"*/*")=5	text	NO
M2:M3	Expression	=COUNTIF($G3:$AA3,"*/*")<>5	text	NO