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 been organized as planned)
Thus, I try to apply a conditional formating on an excel column = the colour red on the colomn B if the colomn B is ="Non" and if the column A>AUJOURDHUI()
I did not find of to do it... Attachement the folder with the 2 columns.
Thanks for helping me !
- Bonjour Clemence:
if you can send just part of the worksheet and clearly explain your goal, I can send you a vba code with an if statement that will help you.
J'ai tente de telecharger le worksheet que tu as envoye mais sans success. Avec VBA tu peux facilement resoudre ce probleme. Tente de poster le worksheet.
Good luck.Hi,
Just for my interest - why VBA is needed for such kind of conditional formatting?
- Hi Sergei:
There is more than one way of achieving the same thing in Excel. After I read the post my mind went straight to vba. You can certainly accomplish the same thing with simply excel.
Thank you.
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.
