ExcelBanter - Conditional Format on returned value

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Conditional Format on returned value (https://www.excelbanter.com/excel-programming/341606-conditional-format-returned-value.html)

Patrick Simonds

Conditional Format on returned value

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.

Norman Jones

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.

All times are GMT +1. The time now is 05:34 PM.