When I use the conditional formatting I am not able to find where I can color
adjacent cells as well, I can only color the one cell in reference

"jordun" wrote:


Hi Todd

You can't change formatting with formula.
But you can use Conditional Formatting (Format---Conditional
Formatting). There you can control the format of a range (or individual
cell) according to its value or by means of a formula.

You can use, of course, Vba.


--
jordun


------------------------------------------------------------------------
jordun's Profile: http://www.excelforum.com/member.php...o&userid=33118
View this thread: http://www.excelforum.com/showthread...hreadid=529349