=AND($G1>=I$1,G1<j$1,$H1>I$1)
=+AND(NOT(I$1<$G1),not(I$1>$H1))
These are the formulas I have for my conditional formating I want to add to them to read column E to know what color to fill cell instead of choosing formating color for each section. see attached
Bookmarks