conditional formatting of column based on text in that column AND another column

[Deleted]

I keep a sales log  updated daily with stock numbers of sold vehicles. How would I format the cells in column D to be highlighted if the stock number starts with "R" AND the value in column B is "N"? And then how would I set a cell elsewhere to count those highlighted cells?

[#2]

If you range starts from row 1 you may apply conditional formatting rule with formula

=(LEFT($D1,1)="R")*($B1="N")

To count such

=SUMPRODUCT((LEFT($D1:$D2000,1)="R")*($B1:$B2000="N"))

or what is your range