ExcelBanter - Formatting based on other cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formatting based on other cells (https://www.excelbanter.com/excel-discussion-misc-queries/454003-formatting-based-other-cells.html)

Milo Bloom

Formatting based on other cells

I want to have a cell turn red font (Conditional Formatting)
I want cell cells in column H to turn red if they are not between two different Cel columns j9 .& k9. I would also like Column P to read pass / fail on either this condition or N9... < O9....
I have attached the sheet here
http://pourtney.com/ASTM/Weekly%20Su...20Ver%203.xlsx

Thanks in advance for any help.

All times are GMT +1. The time now is 02:07 PM.