I have a church rota Google Sheet. Column A shows the date of each service.
To make it more obvious at a glance, I would like cells in column A to apply formatting so that dates in the past are colored differently. Ideally, the next upcoming date would be highlighted (or at least dates in the current month or something like this).
I am somewhat familiar with conditional formatting but not using it on dates – is this feasible and if so how can I do it? In a perfect world, the entire row would be colored for past weeks but just the cell is sufficient if this is getting tricky.
In an Android application, I have to display images during texts. For example:
So image must be a part of text without border, shadow, … or with
button effect. Problem is that sometimes image does not load properly, for example:
Now I have to denote that image is refresh-able by clicking it. How I can denote this with keeping image as part of text?
- Really above problem occurs at run-time and my application cannot detect loaded/generated image is incomplete, else it could try for reloading/regenerating.
- My application is a
- a card may contain more than one image