Hi Group,

I have a range of cells (H10:H24) that contain a 'nested IF-OR formula'
that returns either blank or a value.

How do I set conditional formatting to have the cell not filled if
the formula returns blank but filled if it returns a value?

Thanks for any help
Martin

Highlight cells and in CF:

Formula is: =H10<"" and set format

OR (If numeric values)

Cell Value: is greater than 0

HTH

"MartinW" wrote:

Hi Group,

I have a range of cells (H10:H24) that contain a 'nested IF-OR formula'
that returns either blank or a value.

How do I set conditional formatting to have the cell not filled if
the formula returns blank but filled if it returns a value?

Thanks for any help
Martin

Hi Toppers,

I can't seem to access the groups with OE so I hope this gets through.

Formula is =H10<"" works great. Thanks!

cell value is greater than 0 was what what I was trying but for some
reason it just doesn't seem to work. I tried quite a few variations
but nada!

Anyway the formula is works so thanks again

Regards
Martin

Thanks for the feedback.

"MartinW" wrote:

Hi Toppers,

I can't seem to access the groups with OE so I hope this gets through.

Formula is =H10<"" works great. Thanks!

cell value is greater than 0 was what what I was trying but for some
reason it just doesn't seem to work. I tried quite a few variations
but nada!

Anyway the formula is works so thanks again

Regards
Martin