If statement

[xxsalahxx]

Hello I would like to add to this piece of analysis below to pick up if Cell L6 is coloured red is there a way to do this please?

=IF(E6="","",IF(B6="",TODAY(),E6)-B6)

Thank you in advance

 

[Fluff]

If L6 is being filled manually then you will need a macro.
If L6 is being filled by a CF formula, then you can use that formula to determine if L6 is red

 

[xxsalahxx]

If L6 is being filled manually then you will need a macro.
If L6 is being filled by a CF formula, then you can use that formula to determine if L6 is red

Hello than you for your response there is also text in the cells that would say - Extreme (Category 1) (Red Event) and also - Major (category1) (red event)

Can it be pulled by text?

 

[Fluff]

What do you want to do if L6 contains the word red?

 

[xxsalahxx]

What do you want to do if L6 contains the word red?

Yes please

thank you

 

[Fluff]

Yes please

thank you

It would help if you answered my question?

 

[xxsalahxx]

Oh sorry I must have misunderstood I have around 1000 rows of data.

Iwas only asking about one row and I would drag the analysis down

Based n the analyss above and also count if the word red appears in col L

thank y

 

[Fluff]

With regard to the formula you posted in your op, how do you want to change it if L6 contains the word "red"?

 

[xxsalahxx]

With regard to the formula you posted in your op, how do you want to change it if L6 contains the word "red"?

Hi
At present I am counting days between 2 columns

I would only like to count the number of days between that is coloured red from column L and to ignore others do you think this is possible? or to count the red cells that have certain text in it which is:

Extreme - (Category 1) (Red Event) and Major (Category 1 ) (Red Event)



Thank you so much for ay help.

 

[Fluff]

How about
=IF(AND(ISNUMBER(SEARCH("red",L6)),E6<>""),IF(B6="",TODAY(),E6)-B6,"")