I have created a sheet to manage my stock levels, I have formatted columns J, K, O, and S to highlight red if the expiry date has been exceeded and green if the expiry date falls within 2 months from today. When there is no date in these columns they show red. I want the columns to stay white. What can I do?
Md Ariful Islam
বিএসসি(সিএসই)
,
এমবিএ(মার্কেটিং)
4 views
1 Answers
Dr. Md Rushad Rahman
এমবিবিএস(আরপিএমসি)
,
পিজিটি(মেডিসিন)
You can create a new rule -- "Format only cells that contain", hit "cell value" and choose "blank" instead. Pick whatever formatting you desire. Then ensure this rule is applied first (Applied in Order Shown), and that should solve your problem.
4 views
Answered