Conditional formating

R

Ryan

I would like to use a set of conditional formats to fill a cell with a
particular color based on that cell having a numeric value only in it. If the
cell is blank or contains text I want it to stay the original color so that
if the value "..1" is entered it remains the original color but if ".1" is
entered the cell will fill with 2nd color. Any suggestions?
 

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

Top