Hi,
I have a large spreadsheet for each salesperson that has 25 questions for
them to answer for each of their customers. What I want to do is have all
questions not answered (blank cells) turn a color and then change to no color
when they are answered. I would really appreciate it if someone could help
me.

Thanks!
PJH

Hi,
Do conditional formating, where the formula is enter

A1=""

then choose the color you want to see when the cell is blank

if this helps please click yes thanks

"PJH" wrote:

Hi,
I have a large spreadsheet for each salesperson that has 25 questions for
them to answer for each of their customers. What I want to do is have all
questions not answered (blank cells) turn a color and then change to no color
when they are answered. I would really appreciate it if someone could help
me.

Thanks!
PJH

Format/ Conditional Formatting/ Cell Value is/ =""
Choose your preferred format pattern.
--
David Biddulph

"PJH" wrote in message
...
Hi,
I have a large spreadsheet for each salesperson that has 25 questions for
them to answer for each of their customers. What I want to do is have all
questions not answered (blank cells) turn a color and then change to no
color
when they are answered. I would really appreciate it if someone could
help
me.

Thanks!
PJH