colour cells

Hi guys, I'm sure this is pretty basic question, but I seem to be struggling to make it work. I have my work schedule which automatically populates and changes the cell colour if I am working on a particular date. I would like to have a list of dates for my leave outside the calendar and the...

Hi all, I am creating a spreadsheet to track job progress. Each job has upto 8 different tasks. For each task I have 3 columns in a table named "Required", "Booked" and "complete" Required will a yes/no from drop down box booked and received will contain dates I then have 8 columns in the...

Hi, good morning, I would like to know if there is a way of counting cells by colour (when they have been coloured by conditional formatting). (I would prefer not to copy again the formulae of the conditional formatting), Any help will be appreciated, Thanks in

Hello, I want to conditionally format an entire row, only if one of the cells contains the word issue. e.g. - cells A2:I2 to conditionally format to orange if cell C2 = Issue Help appreciated:) Cal

Locking text in cells but not the ability to change colour of cells<ins style="text-decoration: none; display: inline-table; border: none; height: 60px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 234px;"><ins id="aswift_0_anchor" style="text-decoration: none...

Hello Experts, I wrote this one liner for my check box but is not working. What should I be doing to make it work? Private Sub CheckBox1_Click() If CheckBox1 = True Then Range(A1, A10).Interior.ColorIndex = 20 Else: Range(A1, A10).Interior.ColorIndex = xlNone End If End Sub...