|
|
#3
05-01-2021, 11:30 AM
|
||||
|
||||
Yes you can, easily, but in tables you need to use indirect references
2021-05-01_192010.png with a formula: 2021-05-01_192542.png but this is very basic conditional formatting and based on guesswork. Best to attach a workbook with both sheets and we can add working conditional formatting which will cover more columns of highlighting. 
|
| Tags |
| excel 2013 formula, forms, formula help |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need a formula to help track attendance | westendj | Excel | 1 | 07-13-2017 11:44 PM |
| Attendance Analysis | LarryLee87 | Excel Programming | 4 | 11-23-2016 05:14 PM |
| Export meeting attendance to .csv/Excel | danieljoachim | Outlook | 0 | 02-05-2015 06:44 AM |
| Create an attendance sheet for monthly club meeting | jcc285 | Word VBA | 0 | 08-30-2014 09:34 AM |
| Automate Office Attendance | kgwack | Outlook | 0 | 02-14-2012 09:39 AM |
Windows 10 
Office 2019
Threaded Mode