Format?

[JOEE1979]

is it possible to have the "hours" column be grayed out unless "OT" or "Rover" is in the reason column?
I need this to be running the whole time, not just when someone runs a macro.
I hope I'm making sense.

Thank you

Shift Update.xlsm
	K	L	M
970	Attendance
971
972	Reason	Employee	Hours
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
Shift Update

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H973:M992	Expression	=MOD(ROW(),2)=0	text	NO

Cells with Data Validation
Cell	Allow	Criteria
K973:K992	List	=Reason
L973:L992	List	=Employee

 

[Joe4]

You would just add another level of Conditional Formatting, and give it precedence over your current Conditional Formatting.
Your formula rule would look something like:

=AND(K973<>"OT",K973<>"Rover")

and choose the gray fill color.

 

[breynolds0431]

You could use more conditional formatting in column M. See below example.

Book1
	K	L	M
970	Attendance
971
972	Reason	Employee	Hours
973	OT
974	Rover
975	nothing
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
M973:M993	Expression	=OR(K973="OT",K973="Rover")	text	NO
K973:M992	Expression	=MOD(ROW(),2)=0	text	NO

 

[JOEE1979]

Thanks guys, it worked

 

[Joe4]

You are welcome.
Glad we were able to help.