Conditional Formatting with IF command

I'm looking to do the below in a cell but I have no idea how to make it work

IF F2 is between (C2-E2) and (C2+D2) then CELL says PASS (green cell colour with black text) UNLESS H2 AND/OR I2 are populated, in which case it becomes between (C2-H2) AND/OR (C2+I2)

IF F2 is not between (C2-E2) and (C2+D2) then CELL says FAIL (red cell colour with black text) UNLESS H2 AND/OR I2 are populated, in which case it becomes not between (C2-H2) AND/OR (C2+I2)

TIA

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. The sample layout accurately matches that of your real data. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

These entries are identical in terms of the criteria:

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B	C	D	E	F	G	H	I	J	K
2	1U	Diameter	7.000	0.100	-0.100	7.000	mm			PASS	IF Actual is between UL and LL, unless Min and/or Max Concession are present, overwriting UL / LL
3	1V	Diameter	7.000	0.100	-0.100	7.000	mm			FAIL	IF Actual is not between UL and LL, or Min and/or Max Concession limit if they are present

Sheet: TABLE

So how can one be a pass and the other a fail?

Please give FIVE rows showing FIVE DIFFERENT scenarios (including override values) and their EXPECTED RESULTS.

One isn't a PASS and one isn't a FAIL, I added that to explain the output I was after. I have updated the 5 cells with actual values and what would be a pass or a fail

Not a very sensible thing to do!!!

No need to quote whole posts - don't do it, please (it's just clutter).

I'll have a look at the new sample workbook.

Here's the formula:

=IF(A2="","",IF(AND(F2>=C2+IF(H2="",E2,H2),F2<=C2+IF(I2="",D2,I2)),"PASS","FAIL"))

Then you can set two CF rules, one for PASS and one for FAIL (I presume you know how to do this bit).