Conditional Formatting Formula

[moif10]

Quick question - I want to use conditional formatting to change the colour of a cell based on two outcomes in other cells. See the image below.

For example, if the severity is between 4 and 5 and the RPN fall between 13-62 i need the cell to turn red. One cell has a severity rating based on the table and the RPN number is a calculation of three other numbers.

Hope this makes sense.

Ta

 

[Peter_SSs]

Welcome to the MrExcel board!

Quick question

That usually means that it is not.

if the severity is between 4 and 5 and the RPN fall between 13-62 i need the cell to turn red

If that is so, then wouldn't that just mean the top left one of your current red cells would always be red?

 

[moif10]

If the severity was 4 and the RPN was between 7-12 and want the cell to go yellow but if the severity was 2 and the RPN between 7-12 i want it to go green.

Make sense?

I was assuming it would require an IF formula??

Thanks,

 

[Peter_SSs]

the cell

What cell? Are you referring to a cell in this table you have shown or a cell somewhere else?

 

[moif10]

The cell i mean is on the spreadsheet. See image below:

I want the RPN cell to change colour depending on the the severity and calulation between the severity x occ x det

In the above example the RPN is 24 and the severity is 4 meaning i need the cell to go red.

 

[Peter_SSs]

See image below:

Not sure how we could have guessed that from post 1.

Also please investigate XL2BB for providing sample data & expected results to make it easier for helpers to understand just what you have & where it is & we can easily copy for testing, unlike an image.

See if this does what you want.

20 08 24.xlsm
	E	F	G	H	I	J
1	Sev					RPN
2	4					24
3	2					24
4	5					13
5	4.7					12
6	4.7					62.1
7	4.7					62
8
CFSev

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
J2:J10	Expression	=AND(ABS(4.5-E2)<=0.5,ABS(37.5-J2)<=24.5)	text	NO

 

[moif10]

Hi Peter,

With a little extra help, we managed to use your formula to perform the task as required.

Thanks a lot.

Scott

 

[Peter_SSs]

Hi Peter,

With a little extra help, we managed to use your formula to perform the task as required.

Thanks a lot.

Scott

Good news! Thanks for letting us know.