How to format cell within a column using conditional formatting with multiple conditions

[sgderrick]

hi All,

I am trying to highlight cells that meet multiple conditions.

For example: I would like to highlight the cell in column I (e.g. 18875367) if cell in E row = D1 (blank) and if cell in H row is <=G1 (in this case I put 2024-01)

Is there anyone who can help me out? I only know how to highlight cell with single numeric conditions.

 

[Georgiboy]

Perhaps the below will help:

Book1
	A	B	C	D	E	F	G	H	I
1	(blank)						2024-01
2
3
4					(blank)			2024-02	1
5					(blank)			2025-02	2
6					(blank)			2024-01	3
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I4:I6	Expression	=AND($E4=$A$1,--SUBSTITUTE($H4,"-","")<=--SUBSTITUTE($G$1,"-",""))	text	NO