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
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