Using Unless or If in the formula

[Fire Marshal]

I am trying to create a formula that will change the color of B7 if the number in H7 is greater than 10 unless D7 has the word Approved in the cell. For any other word in D7, the cell would change color. Any help would be greatly appreciated. Thanks

 

[Fluff]

Hi & welcome to MrExcel.
How about

=and(h7>10,d7<>"Approved")

 

[Bosquedeguate]

How about this for Conditional Formatting ...

Book2 (Autosaved).xlsm
	A	B	C	D
1	xxx	11	not approved
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=AND((B1>10),UPPER(C1)<>"APPROVED")	text	NO

Book2 (Autosaved).xlsm
	A	B	C
1	xxx	11	approved
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=AND((B1>10),UPPER(C1)<>"APPROVED")	text	NO

Book2 (Autosaved).xlsm
	A	B	C
1	xxx	10	not approved
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=AND((B1>10),UPPER(C1)<>"APPROVED")	text	NO

 

[Fluff]

There is no need to use UPPER as <> is not case sensitive

 

[Fire Marshal]

Hi & welcome to MrExcel.
How about

=and(h7>10,d7<>"Approved")

Hi & welcome to MrExcel.
How about

=and(h7>10,d7<>"Approved")

That worked great. Thanks

 

[Fluff]

Glad we could help & thanks for the feedback.