Forum Discussion
Need help- conditional formating on an excel cell with the formula SI(ET) (2 conditions)
Hello everybody! I need to notice when the date of a planned event is past but it is written in the column B (status) that this event has not been realized (it means that a planned event has not ...
Hi Clemence,
I guess AUJOURDHUI means TODAY in English. With your sample you may apply the rule
=($A25>TODAY())*($B25="Non")
on region
=$A$25:$B$34
as in attached
Could you tell me the reason for using * ?
In this case no difference. We have to use asterisk instead of AND in some array operations; AND within INDIRECT doesn't work with conditional formatting; maybe something else.
Not to think I always prefer asterisk.
