Grid turn to white with conditional formatting

[ethelbertmagnus]

Hello team,

I have cells that contains an array formulas, results are dynamic, sometime, they spill 10 cells and sometimes they spill on 50 cells. Can I use conditional formatting, when there is not value on the cell, just outer and inside grid turn to white.

I tested multiple times, and I thought that wouldn't be possible; just I want to make sure there is no solution for it.

This is what I entered in conditional formatting: = OR ($F$4 <0 , $F$4 = " ") do this ...

Regards,

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

Windows 10 is not your Office version - please update your profile with the correct information.

[Pete_UK]

Also, you have a space in your second term. If you want to test for the cell being empty you should have:

= OR ($F$4 <0 , $F$4 = "")

and you might want to change the first term to <= 0

Hope this helps.

Pete

[ethelbertmagnus]

Ok, thanks!!!