Thank you for looking at my question,
What I wanted was for the all the text in all rows where the value in cell(Qrownumber) is greater than the value in cell (Urownumber) - the code below doesn't quite do that (only some of the cells turn red and the q value in those rows isn't greater than the U value) - how should I do it please?
.Range("A3:U" & lngBOMRows).Select
With Range("A3:U" & lngBOMRows).FormatConditions.Add(Type:=xlExpression, Formula1:="=Q1>U1")
.Font.Color = vbRed
.StopIfTrue = True