Monday, April 30, 2018

yogi_Conditionally Format DashBoard!G1:G15 If Attendance!G2:G Does Not Have Today's Date

Google Spreadsheet   Post  #2441

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Apr-30-2018

question by: Zatin!topic/docs/Szwi02eSqek;context-place=mydiscussions
Conditional Format Column based on Dates in Another Tab

In DashBoard!G1:G15 range I need to apply conditional format.


If in Attendance!G2:G range <> Today() 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.


Please Help.


No comments:

Post a Comment