wow, this was a lot easier than I made it, thank you to everyone for helping
stupid me get this one figured out!
"Bob Phillips" wrote:
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