Conditional Formatting to match cell values
I have entered the values 1-40 in a block of cells, say E20:I27.
I want to enter the numbers 1-40 in a random order down Column A. When the value has been entered down Column A I want the corresponding value in the range E20:I27 to be formatted in some way. I have tried a few variations but had no joy! |
Conditional Formatting to match cell values
Try conditional formatting with a formula of
=COUNTIF(E20:I27,A1)0 and format as required -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mick B" wrote in message ... I have entered the values 1-40 in a block of cells, say E20:I27. I want to enter the numbers 1-40 in a random order down Column A. When the value has been entered down Column A I want the corresponding value in the range E20:I27 to be formatted in some way. I have tried a few variations but had no joy! |
Conditional Formatting to match cell values
Thanks for trying but....
when I put a value in column A it merely highlights the first number in the block (E20), then does not work at all for subsequent entries down Column A. Any other ideas? "Bob Phillips" wrote: Try conditional formatting with a formula of =COUNTIF(E20:I27,A1)0 and format as required -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mick B" wrote in message ... I have entered the values 1-40 in a block of cells, say E20:I27. I want to enter the numbers 1-40 in a random order down Column A. When the value has been entered down Column A I want the corresponding value in the range E20:I27 to be formatted in some way. I have tried a few variations but had no joy! |
Conditional Formatting to match cell values
Mick
You have another post going in another news group. Why not stick to the one posting? Bob has given you the same answer you got at other post. Gord Dibben MS Excel MVP On Wed, 2 Apr 2008 07:00:09 -0700, Mick B wrote: I have entered the values 1-40 in a block of cells, say E20:I27. I want to enter the numbers 1-40 in a random order down Column A. When the value has been entered down Column A I want the corresponding value in the range E20:I27 to be formatted in some way. I have tried a few variations but had no joy! |
All times are GMT +1. The time now is 05:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com