Notification showing when date entered

[soumendas001]

In a excel sheet 3 columns (Start date, end date and duration). When I entered start date a notification showing "OPEN" in duration cell. And after entered end date it is change to total duration of the day.

For example: I enter start date 15-april-2020 in the duration cell automatically showing "OPEN" with some color highlighted. After that when I enter end date 17-april-2020 it will change to 2 days.

 

[Joe4]

Welcome to the Board!

So your formula would look smething like this (place in column C):
=IF(B2>0,B2-A2,"Open")
and be sure to format column C as "General" (and not a date format).

If you want to have a check for column A too, you can do:
=IF(B2>0,B2-A2,IF(A2>0,"Open",""))

 

[soumendas001]

First of all thank you very much for your prompt reply. Second formula is working excellent. It is matched exactly what I want. But one thing not fulfill. I want when "OPEN" showing in column "c" automatically format Yellow fill color. How to do that?

 

[Joe4]

Use Conditional Formatting.
- Highlight column C,
- Go to Conditional Formatting and select the "Format ony cells that contain: option.
- Enter the following rule: Cell Value equal to Open
- Select the Format option
- Go to the Fill tab and select the yellow color and click OK twice.

This should do what you want.