I have encountered numerous questions related to changing a cell color based on its value, which can be achieve easily with Excel "Conditional Formatting". However I'm interested in changing a cell color based on some other cell value.
For example, I want cell
A4 to be painted red only if cell
B4 has a greater value than
A4 cell. Is there any way to accomplish that?
I've found this guide which actually explains what I need pretty well, but how can I expand this formatting to numerous cells? Just dragging doesn't work here for me.
EDIT: I'm using the Excel 2007 version.