excelquestion123
New Member
- Joined
- May 25, 2008
- Messages
- 23
Hi,
I use a conditional formatting rule to compare four columns of stock item prices. The conditional formatting rule highlights those items which price is different (see copy of original Q&A post below). My question is how i can use the same rule but create a threshold of $0.05 (5 cents). By this i mean if A1 was 10.00 and B1,C1,D1 were 10.01 they would not highlight but if A1 was 10.00 and B1,C1,D1 were 10.06 then the conditional formatting rule would apply.
Following is my original question i posted on Mr excel with the answer that works only with out a threshold.
Highlight range B1:D300 (selecting B1 first) and apply a Conditional Format Formula based rule of:
=B1<>$A1
format as appropriate
I use a conditional formatting rule to compare four columns of stock item prices. The conditional formatting rule highlights those items which price is different (see copy of original Q&A post below). My question is how i can use the same rule but create a threshold of $0.05 (5 cents). By this i mean if A1 was 10.00 and B1,C1,D1 were 10.01 they would not highlight but if A1 was 10.00 and B1,C1,D1 were 10.06 then the conditional formatting rule would apply.
Following is my original question i posted on Mr excel with the answer that works only with out a threshold.
ORIGINAL QUESTION I POSTED ON MR EXCEL
I have a set of data which consists of 4 columns of number values. The columns go for hundreds of rows down.
I would like any cells within a row with a value different to that of the first cell in that row to be highlighted.
IE. if cell a1 was the number 10. Cells a2 and a3 were 10. and cell a4 was 15. i would like cell a4 to be highlighted.
ANSWER
If you have as you say only a few hundred rows... assume data is in A1:D300I have a set of data which consists of 4 columns of number values. The columns go for hundreds of rows down.
I would like any cells within a row with a value different to that of the first cell in that row to be highlighted.
IE. if cell a1 was the number 10. Cells a2 and a3 were 10. and cell a4 was 15. i would like cell a4 to be highlighted.
ANSWER
Highlight range B1:D300 (selecting B1 first) and apply a Conditional Format Formula based rule of:
=B1<>$A1
format as appropriate
