Highlight cell if two columns don't match two other columns

[Tarvalon14]

Hi, I was a board regular many years ago. I've been away for a while now. I am in need of help, please. I really don't know what to search for so I'm sorry if this has been answered. See below!

I need my workbook to make sure that an employee is charging the correct code and if not to highlight a cell or give me an error message. Some employees don't charge to these projects so the cells may be blank. Also, I would like for it not to return an error if there is a correct charge number but they didn't work on the projects. Would it be possible to return an error if they did charge when they're not set up to charge as well?

The master roster tab contains the employee information and the correct charge codes. I can't change this spreadsheet around much. It gets compared to the client timesheet audit tab.

A	B	C	D (unique value)	E **
Name	Last Name	First Name	Employee ID	Charge Codes
Jon Snow	Snow	Jon	SNJO00001	1234 (error message because he charged the wrong code)
Cersei Lannister	Lannister	Cersei	LACE00003	1234 (no error message because she didn't charge the code)
Sansa Stark	Stark	Sansa	STSA00002	(different error message because she charged and isn't set up)
Robert Beratheon	Beratheon	Robert	BERO00004	6789 (no error message because he charged the correct code)

The client timesheet audit tab contains the projects and charge numbers that were actually charged. I can change this query up however I need to. This is just a data dump from a database. There will be multiple entries for the same employees and I need error messages if anything is charged improperly.

A	B	C (unique value)	D	E	F **
First Name	Last Name	Employee ID	Date	Project Number	Charge Codes
Jon	Snow	SNJO00001	10/31/2022	1996	1234
Jon	Snow	SNJO00001	10/29/2022	1996	2345
Sansa	Stark	STSA00002	10/28/2022	1996	1234
Robert	Beratheon	BERO00004	10/27/2022	1996	6789

Thanks in advance.

 

[gelu]

Could you do Data Validation for the cell where the employees charge the codes? That way they should be able to select the correct code.

Book1
	A	B	C
1
2
3	Worked on Project?	Cells to select code	Charge
4	1	1222	1222
5	0	2334	0
6	0	3345	0
7	1	3345	3345
8
9		Charge code list
10		1222
11		2334
12		3345
13		1111
14
Sheet2

Cell Formulas
Range	Formula
C4:C7	C4	=B4*A4

Cells with Data Validation
Cell	Allow	Criteria
B4:B7	List	=$B$10:$B$13

For data validation of cell B4.

Prepare a list of charge codes

1 - select B4
2 - go to Data
3 - select data validation

4 - Allow List
5 - Select the cells that host the list

6 - Just copy b$, it will copy Data Validation settings, too.



You could add a column which deals with worked on project (1) or not (0)

 

[Tarvalon14]

I can not. This is all data dumped from two different databases.

 

[Tarvalon14]

I can not. This is all data dumped from two different databases.

But thank you