Conditional Formatting

[Crispyboggins]

Morning,

I have a spreadsheet Training Matrix with multiple columns. In colum D is has the value of 1 if training has been completed or 0 if not completed. In colum E there is a option for the date of training. Column D is updated from another sheet so what i need to do is for the coresponding cell in column E to change colour if no date is entered so the Training Officer knows that a date needs to be entered. E.g if D5 was 0 E5 will do nothing but is D5 is 1 and E5 is blank E5 will turn RED

 

[Snakehips]

Try like..

Book1
	D	E
4	Trained	Date
5	1	01/01/2020
6	1
7	1
8	0
9	1	05/01/2020
10	1
11	0
12	1	08/01/2020
Sheet7

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E5:E13	Expression	=AND($D5=1,$E5="")	text	NO

Hope that helps.

 

[Crispyboggins]

Hi Snakehips,

Thanks for this. Not sure if I am doing something wrong but its not doing anything... Have posted the Conditional Formatting Screens below. Anything you can think of?

 

[Snakehips]

The fact that you expect the Training Officer to enter the dates in E leads me to believe that cells in E are normally empty.
No formulas in E, Is this the case?
Also, no danger you have any stray spaces incells?

 

[Crispyboggins]

Yeah cells in E are empty till date entered. Not sure if this makes a difference. Have added column C below as well. So Column C populated from a nother sheet within the workbook with a simple cell = cell formula. Column D has the formula =IF(C5>0,"1","0") which fills in column D. Does that cause any issues?