You select the adjacent cell and apply the same condition to it, referencing
the other cell.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Todd Nelson" wrote in message
...
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