Dec 03 2018 09:48 AM
Dec 03 2018 09:48 AM
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?
Dec 03 2018 02:19 PM
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