Hello,
I'd like to CF a few columns based on text in a adjacent column. For example, I have a data validation list in B1 with the options "Y" or "N" and I want to format A1 based on each value; B2 has "N" to format A2, B3 to format A3 and so on. This is simple enough for a single row but I can't figure out how to get this to work for the entire column or multiple rows. Is this even possible? Any assistance is greatly appreciated.
Thanks
- Jesse