View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Conditional Format on returned value

Hi Patrick,

Try:

Formula Is: =ISNUMBER(A1)

---
Regards,
Norman



"Patrick Simonds" wrote in message
...
I have a formula in cell A1 which if the right conditions are met will
display a value between 1 and 31, in cell A1. If the condition is not met
the cell remains blank. I need a conditional format that will work any time
a value is returned by the formula. Everything I have tried views the
formula as a value.