Forum Discussion
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...
Not everything is clear, at least for me. Looks like
- we have the range with 500 rows and 500 columns size;
- somewhere outside this range (aka data) there is another range with 500 rows and 2 columns size;
- In columns of the later are defined bounds for the correspondent rows of the data range, min in first column and max in second one
- all values in data range which are out of this bounds for the correspondent row shall be highlighted by red color
- Hello Sergei,
You got this correct.!
In columns of the later are defined bounds for the correspondent rows of the data range, min in first column and max in second one
- all values in data range which are out of this bounds for the correspondent row shall be highlighted by red color.
This is exactly what I`m trying to do where as the bounding values for each row are varying.That is close to what Ramiz_Assaf suggested. Assuming SI is column with down bound and SJ is with upper one, you may use the rule with formula
=(A1<$SI1)+(A1>$SJ1)
