Thread: [Solved] Auto Color Fill Question
View Single Post
 
Old 05-02-2013, 03:45 AM
OTPM OTPM is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default
Hi Kevin
Your formula will work up to a point. However if values lower than 0 in the ASCII table are entered your formula will not work. Try this formula which covers "ANYTHING" entered in cell E1:
=NOT(ISBLANK($E1))
Good luck.
Tony
Reply With Quote