little bit of an odd challenge, well it is for me anyways....can't seem to crack it....
Using conditional formatting I want to set up a spreadsheet so that an entire column will highlight if it contains a value I'm looking for...for example if the value I want is in A37 I want from A1 through...