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...
There are several methods, few I would like to show here:
How it works:
- Select Q2:R8, and hit Conditional Formatting
- Find Top & Bottom Rule, from menu hit More Rules.
- Select Format only Top or Bottom ranked values.
- Select TOP then 1 & Bottom then 1 and apply an appropriate format, finish with Ok.
N.B. For Applied to the range, for the TOP 1 the range must be, R2:R8. and for Bottom 1 the range must Q2:Q8.
Another is the dynamic way:
- In any blank cells find Maximum & Minimum from both columns.
- Use these as rules:
=$U2=$X$2 and =$V2=$X$1
- You may adjust cell references in the formula.
- Hello Rajesh,
In the provided example of the Excel sheet. The first two columns would be deciding factor for the rest of the dataset. I would want to highlight all the row items which wouldn't fall under this two row items of the columns.
