I have a spreadsheet with 12 coloums. In the last coloum are the words "yes", "no", or is empty (null?). I need to find a way to have each row that contains the word "no" or is empty to be highlighted in red font and bold type. When the word "yes" is typed then the font is black and the type in normal.
This allows me to see at a glance what orders have not been picked up or have problems.