Thank you for looking at my question,
I use the vba code below to grab data from an Excel workbook.
The number of rows will vary but there will always only ever be four columns.
For each row I would like to cell background colour in columns 1,2,3 and 4 to turn red if the cell value in cell 4 is greater than 6.
How can I achieve this please?
Dim wbk As Workbook
Dim destWbk As Workbook
Set destWbk = ActiveWorkbook
FileToOpen = "K:\Working Data\Loading.xls"
Set wbk = Workbooks.Open(FileToOpen)