Hi Mark,
see
http://www.mvps.org/dmcritchie/excel/condfmt.htm
you probably want to use a formula like =A1=""
or perhaps =TRIM(A1)=""
if A1 is the active cell in your selection when you do the Conditional Formatting.
$A1 would be good for coloring the entire row based on the cell in Column A.
---
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
"Markitos" wrote in message ...
Thanks for your answer it was of great help.
I found something rather hard though, I cant copy the formula to other
cells, I wanted a whole row to use this formula, but if I copy a cell to
others it doesn't change the formula to correspond with the new cell, its
leaving the cell # the same.
Thanks for your help.
"Jason Morin" wrote:
=$A$1=""
HTH
Jason
Atlanta, GA
-----Original Message-----
Hello
I was trying to make a formula to conditional format a
cell. I wanted the
formula to be (if the cell is blank). I wanted to make
the cell have a red
border if it was blank. I know how to make make the
border red if the
condition is true, but im not sure how to write the
formula for this.
Thanks for your help.
.