I have a workbook with data in cells E3:E23 and I would like the data on those cells to change to red if the value of E8=Inactive
Is it best to do this in VBA or is it possible with conditional formatting? I've some formatting where just the data on E8 changes, but I can not make it so all the cells turn red also!
Any ideas please?
Bookmarks