I am having trouble in excel using conditional formatting for my table. I need to highlight the sample values that are greater than screening_1 or screening_2 for each individual row.If the value is greater than screening_1 I would like the sample values highlighted green, and if the value is greater than screening_2 I would like the sample values highlighted blue. I would also like to exclude highlighting on values where the screening values are blank.I have attached an example of what the table looks like (dummy data) and how I’d like the conditional formatting to be. Thank you!
