I'm using Excel 2007. I'm trying to compare the values in a column to an adjacent column of values. For instance I'm comparing my sales price to my competitors and I'd like to have a different color or font if their sales price is less than our sales price. My price is in column O and theirs are in Column R. I can do this conditional formatting with one cell value compared to another but can't expand it to the entire column.
So you want to compare each value in column O with all values in column R, so that if for eg. O1 is less than any value in column R, then highlight?
Or did I misunderstand?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Sorry about that. No, I want to compare the value in Q12 to O12, Q13 to O13 and so on. and if Q12 is less than O12 make it Red Font with Yellow Fill.
hi,
put this in the conditional format
and format as you said=(q2<o12)
steve
Select range from Q12 downwards (if Q12 is the first cell to compare)
And select Format|Conditional Formatting.
You can select Cell Value Is >> Less Than >> =O12
where O12 is top most cell to compare against.
Click Format and choose your colour from the Pattern tab.
Click Ok twice to finish.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks