Hello,
I'm having trouble with part of my VBA code. I'm up to the part where I am highlighting a range of cells within the current row and adding formatting (i.e. borders). Additionally, I want to add conditional formatting of that same range based on a TRUE/FALSE statement of a hidden cell within that row. Here is the current code; however, it will not update for each row:
I'm assuming I need to change the cell references but not sure how. Any help is greatly appreciated!
Thank you,
Jay
I'm having trouble with part of my VBA code. I'm up to the part where I am highlighting a range of cells within the current row and adding formatting (i.e. borders). Additionally, I want to add conditional formatting of that same range based on a TRUE/FALSE statement of a hidden cell within that row. Here is the current code; however, it will not update for each row:
Code:
With Selection.FormatConditions.Add( _ Type:=xlExpression, _
Formula1:="=OR($J8=TRUE,$I8>0)")
I'm assuming I need to change the cell references but not sure how. Any help is greatly appreciated!
Thank you,
Jay