Spreadsheet formula

  • Thread starter Thread starter PJH
  • Start date Start date
P

PJH

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
 
Format/ Conditional Formatting/ Cell Value is/ =""
Choose your preferred format pattern.
 
Back
Top