VBA - Click to highlight cell/range

Hi,

I'm trying to do the following on the attached "shift spreadsheet";

• Click on either a single cell or select a range in the table to highlight the cells green
• When left clicking on a cell or selecting a range, input "1"
• When right clicking on a cell, input "0.5"
• Clicking on the same cells will remove the highlight and value
• Check the other columns for the day and highlight any cells that don't have coverage red
• Calculate the total number of hours in the last column

I've found a number of formulas that do one or the other but I haven't been able to combine them to get the desired outcome.

Have you done any research, or programming attempts at all? If you want advice when you get stuck, then everyone will help out.

Originally Posted by WideBoyDixon

That's a lot to cram in! Firstly, you can probably achieve the highlight using conditional formulas. For range C4:Z79 use the following formula to colour cells green:

This is perfect, thank you very much!!