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.
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.