canisdibellum
New Member
- Joined
- Mar 7, 2018
- Messages
- 8
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 A70 to turn green
OR
if a value shows up in a column, highlight the first cell in the column...for example if value is at A37 I want A1 to turn green
Cell A37 used in the 2 examples is arbitrary I want any cell in the column to activate the conditional formatting
yes I know it's odd and probably difficult to come up with a use, but is there a way to do 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 A70 to turn green
OR
if a value shows up in a column, highlight the first cell in the column...for example if value is at A37 I want A1 to turn green
Cell A37 used in the 2 examples is arbitrary I want any cell in the column to activate the conditional formatting
yes I know it's odd and probably difficult to come up with a use, but is there a way to do it?