Correction, see
Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

If you do it as I mentioned you only have to apply the formula once
no copying.

"David McRitchie" wrote in message ...
See http://www.mvps.org/dmcritchie/excel/excel.htm
which cells get colored depend on which cells/columns are selected
based on you formula which is adjusted for each cell based on the active cell.
So your formula would use $ in front of the column letter to show /that/ that
column is the one to be tested.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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