Forum Discussion
Legio5556
May 06, 2020Copper Contributor
Custom format blank cell
Hi All I would like to custom formatting a blank cell. I know... 🙂 But there is some reason. The cost column contains positive numbers(sometimes negative numbers) and zero and empty cells. Z...
mtarler
May 06, 2020Silver Contributor
PeterBartholomew1 I like the creativity. But do you even need the formula? why not just type " N/A" and fill down and make column narrow and then if there is a value to the right that cell gets clipped down to the " " and blank cells will show it.
Legio5556 That all said wouldn't conditional formatting highlighting the blank cells be good enough instead of having the "N/A" text?
Legio5556 That all said wouldn't conditional formatting highlighting the blank cells be good enough instead of having the "N/A" text?
Legio5556
May 11, 2020Copper Contributor
Hi mtarler
The aim is to keep blank because of further use but shown as "N/A".
Certainly, everyone could list situations where
- "N/A" is not equal to number 0 or blank cell.
- text by hand is not automatic solution.
- function in a cell could be overwritten ...
Thanks to all 🙂