My Power Pivot data model consists of a number of linked Excel tables, of which tblEvents is the main one. It has the following columns:
Location, related to the column "LocationName" in tblLocations
EventType, related to the column "EventType" in tblEventTypes
Client, related to...
I have a timekeeping sheet that has a macro to insert a new employee and employee number. I want to apply conditional formatting to cell C10 that basically says. If the Employee number they entered was blank, highlight red. And then once they enter the 6 digit employee number it returns to no...