Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
XL2K - Conditional Formatting relative to cell selection
Is there a way I can change the colour of an array of cells depending on whether a different specified cell in the worksheet has been selected? For example, the conditional formula in each cell in the range X1:Z3 would effectively be: 'if A1 is the currently selected cell, turn me green'. :) Thanks - Lez -- Lezh ------------------------------------------------------------------------ Lezh's Profile: http://www.excelforum.com/member.php...o&userid=29962 View this thread: http://www.excelforum.com/showthread...hreadid=496600 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enhanced conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting if any value in the cell | Excel Worksheet Functions | |||
Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |