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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007: Three comparisons 1
How to filter rows data based on background color of individual cells 1
Conditional formatting with formulas 6
Merging Data Into Spreadsheet 2
Formatting a Spreadsheet 2
Change color of answer 5
colors and conditional format - greater than, less than 5
Help with a range formula 4

Back
Top