With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Monday, April 30, 2018
yogi_Conditionally Format DashBoard!G1:G15 If Attendance!G2:G Does Not Have Today's Date
Dates are in dd/mmm/yyyy (27-Apr-2018) or (27/04/2018)
What I plan to achieve is if today's date is missing from the Range G2:G of the Attendance sheet, conditional formatting should be applied on a different Tab (DashBoard) of the same spreadsheet. The range for the formatting to be applied is G1:G15.
The sample sheet shows the intended results.
I managed to come up with the below custom formula but it fails to work.