Remove value of "0" from blank Excel cell
Closed
TDB
-
May 15, 2010 at 10:26 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 15, 2010 at 10:56 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 15, 2010 at 10:56 AM
Hello,
I need to set conditional formatting so if the number 0 - 999 is typed in a cell, the cell fill will be yellow. If the cell is blank, I need it blank. Excel seems to think that a blank cell = 0, how do I change this?
I need to set conditional formatting so if the number 0 - 999 is typed in a cell, the cell fill will be yellow. If the cell is blank, I need it blank. Excel seems to think that a blank cell = 0, how do I change this?
Related:
- Remove value of "0" from blank Excel cell
- //192.168.l.0 - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
- How to remove tiktok shop from my profile ✓ - TikTok Forum
- How to remove number from blacklist - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 15, 2010 at 10:56 AM
May 15, 2010 at 10:56 AM
how about like this
=and(a1<>"", a1>=0, a1<=999)
=and(a1<>"", a1>=0, a1<=999)
