Forum Discussion
clemence jouan
Sep 15, 2017Copper Contributor
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 ...
SergeiBaklan
Sep 16, 2017Diamond Contributor
Hi,
Just for my interest - why VBA is needed for such kind of conditional formatting?
Tihamiyou B Moussa
Sep 16, 2017Copper Contributor
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.
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.
- SergeiBaklanSep 16, 2017Diamond Contributor
Definitely, Excel infinite as universe. Actually the question was what's wrong in simple AND to substitute it by macro. If consider as one of solutions - yes, why not.
- Tihamiyou B MoussaSep 16, 2017Copper ContributorI just joined the community and was not also clear about what our friend who posted the question wants. Since this is a place to share and learn, I decided to share my knowledge. I will follow the final answer if shared in the group.
Thank you.