Conditional Formatting in Macro

[hanzsolo]

Range("Y2").Select
ActiveCell.FormulaR1C1 = "=IF((AND(RC[-23]>RC[-9]+2,RC[-11]>0)),1,0)"

I want to change the entire row to orange if the value in this cell is "1" thru the macro I already have built. The code to determine if it's a one is above and I use an autofill to fill the entire report.

 

[Joe4]

Please continue in your original post on the question instead of starting a new thread for it: http://www.mrexcel.com/forum/showthread.php?t=570153

Thread of a duplicate nature are typically locked or deleted, per forum rules. All clarifications, directly related follow-ups, or "bumps" should be posted back to the original thread per forum rules: http://www.mrexcel.com/forum/showthread.php?t=99490.