Rishek
06-16-2017, 09:41 AM
This line is giving me a compile error "expected: end of statement".
.FormatConditions.Add Type:=xlExpression, Formula1:="=AND(OR$A1="Romano",$A1="De Vita",$A1="Monta",$A1="Ballentine",$A1="Ott",$A1="Holiday",$A1="Skinner",$A1="Crocetto",$A1="Ngqungwana",$A1="Garrett",$A1="Duval",$A1="Woods",$A1="Trevigne",$A1="Becerra",$A1="Burden"),$G1>TIMEVALUE("6:00"),$G1<>"")"
I'm just trying to use it to add a highlight to a set of hh:mm times if the time is over 6:00 hours. Some of the cells in the column are blank. It works in Excel (returning the correct true false values). There's is likely a better way to do this. That'd be totally welcome, but I'd also like to know what's wrong with how I'm entering this formula in the VBA editor for the future.
Thanks!
.FormatConditions.Add Type:=xlExpression, Formula1:="=AND(OR$A1="Romano",$A1="De Vita",$A1="Monta",$A1="Ballentine",$A1="Ott",$A1="Holiday",$A1="Skinner",$A1="Crocetto",$A1="Ngqungwana",$A1="Garrett",$A1="Duval",$A1="Woods",$A1="Trevigne",$A1="Becerra",$A1="Burden"),$G1>TIMEVALUE("6:00"),$G1<>"")"
I'm just trying to use it to add a highlight to a set of hh:mm times if the time is over 6:00 hours. Some of the cells in the column are blank. It works in Excel (returning the correct true false values). There's is likely a better way to do this. That'd be totally welcome, but I'd also like to know what's wrong with how I'm entering this formula in the VBA editor for the future.
Thanks!