Conditional Formatting with two columns and rows of data to 500 x 500 date set

Hello Everyone, I`m trying to create a conditional formatting excel where   1) Two columns      i) Being the lower end of a value <- 1st Column    ii) Being higher end of a value<- 2nd Column I...