Column A is 5 digit Order Number
Column B is Customer name
Columns C thru O are X’s or 0 depending on which stage Order is in.
Using VBA to set conditional formatting for C thru O columns
Using another Rule cell value contains “x” then they have white fill & white copy.
Leaves me with a Red box in whatever stage that order is in.
What I would like to do is have the VBA copy the 5 digit number from A column into which ever cell in row is red/red except of course with whit copy.
BTW the 5 digit number in Column A is also a hyperlink to other excel files.
Any Help??? Thanks
Column B is Customer name
Columns C thru O are X’s or 0 depending on which stage Order is in.
Using VBA to set conditional formatting for C thru O columns
Code:
With ThisWorkbook.Worksheets(1).Range("C3:O3")
.FormatConditions.Delete
.FormatConditions.Add Type:=xlExpression, Formula1:="=COUNTIF($C3:C$3,C3)=1"
.FormatConditions(1).Interior.ColorIndex = 3
.FormatConditions(1).Font.ColorIndex = 3
End WithUsing another Rule cell value contains “x” then they have white fill & white copy.
Leaves me with a Red box in whatever stage that order is in.
What I would like to do is have the VBA copy the 5 digit number from A column into which ever cell in row is red/red except of course with whit copy.
BTW the 5 digit number in Column A is also a hyperlink to other excel files.
Any Help??? Thanks
