|For the "Red Row":|
Right click the sheet tab for the sheet you want the "red row" in and choose View Code. Paste this code into the pane that opens. If you enter any version of "NO" (NO, no, etc.) in Column A, the entire Row will be filled with Red.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
If UCase(Target) = "NO" Then
Target.EntireRow.Interior.ColorIndex = 3
For the System Time:
Attach this code to a macro button. When the button is clicked, the system time will be placed in A1:
Cells(1, 1) = Time
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.