Good afternoon
On the attached sheet I am trying to indicate that enough data has been entered by highlighting the entire column.
Any 3 cells in Rows 7-13 and 18-36 will be filled in with any of the values from cells O6-O11 (hidden). When the total = 6 i would like to highlight the entire column to indicate it has been completed.
The aim is two fold: to ensure that the correct number of points is allocated in each race, and secondly to indicate which column is the next to be filled in (as human error sometimes misses the column and adds the points to either the previous or next columns). You could call it idiot proofing the sheet
At present i have the cells in Row 37 conditional formatted to show this, but would much prefer the entire column to highlight.
Thanks
Darren
Bookmarks