icolor

Hi all, I have a VBA code I am using that will change a specific cell in column L to a fill of yellow or icolor=6 if it matches todays date. If the date in column L is before todays date, I want it to turn red or icolor=3. (I would prefer if it would stay yellow for 3 days instead of 1 day, but...

I'm sure this is gonna be simple for anyone who knows what they're doing... I'm running some code in my workbook - this simply changes cell colour based on value: Public Sub Worksheet_Change(ByVal Target As Range) Dim icolor As Integer If Not Intersect(Target, Range("c8:pf25")) Is...

Can't seem to find an answer to what I think is a relatively simple query.... I'm currently using this code to 'conditionally format' a range of cells containing various text strings... Private Sub Worksheet_Change(ByVal Target As Range) Dim icolor As Integer Dim colorr As Integer If...