| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting of Cells with Multiple Cell Values | Excel Discussion (Misc queries) | |||
| apply conditional formatting to negative cell values | Excel Discussion (Misc queries) | |||
| Complicated conditional formatting if numbers match across a data set..How? | Excel Worksheet Functions | |||
| Complicated conditional formatting if numbers match across a data set..How? | Excel Discussion (Misc queries) | |||
| Values w/conditional formatting | Excel Worksheet Functions | |||
Threaded Mode
