pankajgrover
Board Regular
- Joined
- Oct 27, 2022
- Messages
- 99
- Office Version
- 365
- Platform
- Windows
I am trying to copy exactly same Data Validation lists Cells but blank cell showing 0. How to correct this 0 as blank. here is below example.. Thanks
Cell Formulas | ||
---|---|---|
Range | Formula | |
D1:D5 | D1 | =C1 |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
C1:C5 | List | =COLOR |