Conditional Formatting, I think
Posted by Mo on June 05, 2001 1:20 PM
Ive got a problem that I hope someone will be able to solve.
Assume 2 columns, A & B with lots of entries in them. Now assume we are in column A5. IF Cell A5 is equal to A6, and correspondingly cell B5 is equal to B6. I would like all 4 cells to be formatted to a colour.
So E.g Cell A5=10 and cell A6=10, at the same time Cell B5 & B6 have the entry apple. Then A5 to B6 should be yellow.
Please remember this process needs to happen many times as there are many entries like these.
I will not mind if a different colour is used whenever this happens e.g first instance yellow, second instance red etc.
If anyone can solve this it will be very much appreciated, macros or formulas kindly accepted.