jimgima
New Member
- Joined
- Sep 19, 2006
- Messages
- 26
First off, thank you for taking the time to read my post. I searched for an answer and couldn't find one.
I would like to use conditional formatting on the problem listed below:
I want the data in certain cells of Column B to turn green if they match the value of ANY cell in column C. Also I want it to turn red if matches ANY of values in column D.
Below is an example of how I want it to look.
Column B
211
245
32
456
332
324
334
342
Column C would contain the numbers 32, 324 and 342
Column D would contain the number 456
I know there is an easier way to do this, but due to the constrictions put on us by this pre-existing spreadsheet; I have no other options. Personally I think it's a stupid spreadsheet, but this is what they want. Please help me look like I know what's going on.
Any help would be appreciated.
Thanks.
Jim
I would like to use conditional formatting on the problem listed below:
I want the data in certain cells of Column B to turn green if they match the value of ANY cell in column C. Also I want it to turn red if matches ANY of values in column D.
Below is an example of how I want it to look.
Column B
211
245
32
456
332
324
334
342
Column C would contain the numbers 32, 324 and 342
Column D would contain the number 456
I know there is an easier way to do this, but due to the constrictions put on us by this pre-existing spreadsheet; I have no other options. Personally I think it's a stupid spreadsheet, but this is what they want. Please help me look like I know what's going on.
Any help would be appreciated.
Thanks.
Jim