Using the following formula:
=LEFT($L1,2)="O-"
highlights the entire row if it meets the criteria, if I only want to highlight between columns A to L then how would the formula look?
Thank you all for your patience, I know I still have a great deal to learn but I feel so much more confident about Excel since finding this wonderful site.
Thanks again
=LEFT($L1,2)="O-"
highlights the entire row if it meets the criteria, if I only want to highlight between columns A to L then how would the formula look?
Thank you all for your patience, I know I still have a great deal to learn but I feel so much more confident about Excel since finding this wonderful site.
Thanks again