Alarm indication red/green in excel/ help

0

Hi

I need your experites help to solve the problem.

I have an excel file and every day updating it.

for example:

Cell A1 contains date(any date)

I want cell A3 to indicate any type of indication such

red dot or x symbol or any indication if A2 is

blank after 10 days of the date in A1. 

If A2 is filled, A4 will indicate green dot or any other 

indication.

the data of A1 and A2 is date. It can be any date weather today date or old date of future date.

Answer
Discuss

Answers

0
Selected Answer

I think this formula might be what you are looking for:

=IF(NOT(ISBLANK(A2)),"O",IF(AND(TODAY()-A1>10,ISBLANK(A2)),"X",""))

X is for the red dot.

O is for the green dot.

Discuss

Discussion

Thanks alot 
I will try it today 
and come back with result
Aaa_111 (rep: 2) Oct 25, '16 at 9:50 pm


Thak you very much for the answer 
I try it and it works successfully.

fantastic.
Aaa_111 (rep: 2) Oct 27, '16 at 2:05 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login