Condition Format - dependant on x2 cells

[trevolly]

Hi all.

Is there any way that using conditional format, a cell (K7) can have a colour fill applied if two other cells (L7 & M7) have any content in them? It would be a time stamp in each of L7 and M7 (doesn’t matter what the time stamp is). I would like the conditional format rule to run on K7 only when both of these cells (L7 & M7) have a time stamp in them.

As always appreciate everyone’s help.

Trevor.

 

[DanteAmor]

Try:

varios 27jun2023.xlsm
	K	L	M
7		01:00	02:00
Hoja4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
K7	Expression	=AND($L7<>"",$M7<>"")	text	NO

 

[trevolly]

Hey @DanteAmor That works great. Thank you so much.