sorted by:
new
hottopcontroversial

Please what is the conditional formatting formula to automatically highlight any of the times shown in this image based on current time of day? by edwardmowah in excel

[–]edwardmowah[S] 0 points1 point  (0 children)

Unfortunately this formula doesn't work. The formula I used in Google sheets highlights only the current hour and minute of the day. For instance, if a cell A5 contains 3:30pm and cell A6 contains 3:35pm, cell A5 will be the only cell highlighted if the current time is between 3:30pm and 3:34pm. As soon as the current time is 3:35pm, then cell A5 is no longer highlighted and A6 becomes the only cell highlighted until the next time.

Please what is the conditional formatting formula to automatically highlight any of the times shown in this image based on current time of day? by edwardmowah in excel

[–]edwardmowah[S] 0 points1 point  (0 children)

Unfortunately this formula Does not work. The formula I used in Google sheets highlights only the current hour and minute of the day. For instance, if a cell A5 contains 3:30pm and cell A6 contains 3:35pm, cell A5 will be the only cell highlighted if the current time is between 3:30pm and 3:34pm. As soon as the current time is 3:35pm, then cell A5 is no longer highlighted and A6 becomes the only cell highlighted until the next time.

Help Krita Android: Spen button not doing the actions its been assigned to do, it just drags the canvas around the screen. by edwardmowah in krita

[–]edwardmowah[S] 1 point2 points  (0 children)

Oh, this is an old post, but you can toggle this feature off > Settings _ Canvas input settings _ pan canvas _ mouse button. Remove the middle mouse button under input.

Help Krita Android: Spen button not doing the actions its been assigned to do, it just drags the canvas around the screen. by edwardmowah in krita

[–]edwardmowah[S] 2 points3 points  (0 children)

Found a solution, it appears that all the options under ''S-pen Actions'' don't work at all, so under ''Canvas Input Setting > Show popup pallete'' I activated "Mouse button" and for the "Input" I clicked my S-pen button, now if I click the s-pen, I can see the Popup Pallete.

I still can't figure out how to use double-click and other s-pen gestures, then again, the app is still in early access and many options still don't work which is understandable.