I have the below which fills the cell the color I want if the criteria are met.
I have numerous cells other than C10 that I want this applied to however. How can I alter the below code so it changes the individual cell if the same criteria are met?
The other cells are, C13, C16, G10, G13, G16
![]()
Sub fsdfsf() If Sheets("test").Range("C10") < Sheets("storage").Range("C18") Or Sheets("test").Range("C10") > Sheets("storage").Range("D18") Then Range("c10").Cells.Interior.ColorIndex = 45 End If End Sub
Bookmarks