??conditional formatting??
 

In my spreadsheets there are several cells that depend upon each other and
when one of them is not filled out I have to go back thru the sheet and check
for a blank cell. My question is can I use conditional formatting or a VB
coding to color the cells background that are not filled in if another cell
that depends on it is. Or use something like IfNull to color the background
if the cell is unused.

??conditional formatting??
 

You can, just add a CF formula such as

=A2=""

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"tankerman" wrote in message
...
In my spreadsheets there are several cells that depend upon each other and
when one of them is not filled out I have to go back thru the sheet and
check
for a blank cell. My question is can I use conditional formatting or a VB
coding to color the cells background that are not filled in if another
cell
that depends on it is. Or use something like IfNull to color the
background
if the cell is unused.

??conditional formatting??
 

Bob that works for one of my sheets thanks for the help. One other question
how can I reverse it around and have a cell change color if anything is in
another cell whether it is numbers or letters. I know a little about EXCEL
but my boss think I can do anything he wants a spreadsheet to do.

"Bob Phillips" wrote:

You can, just add a CF formula such as

=A2=""

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"tankerman" wrote in message
...
In my spreadsheets there are several cells that depend upon each other and
when one of them is not filled out I have to go back thru the sheet and
check
for a blank cell. My question is can I use conditional formatting or a VB
coding to color the cells background that are not filled in if another
cell
that depends on it is. Or use something like IfNull to color the
background
if the cell is unused.