Is there a formula to show which cell is currently selected
On Mon, 8 May 2006 03:26:01 -0700, Chris
wrote:
I want to select a cell and then use conditional formatting to highlight
other cells based on the value of the selected cell.
With A1 as the selected cell and C1 as one of your 'other cells, put
conditional formats in C1
Format--Conditional Formatting
In the Condition 1 first drop down box, choose the 'Formula Is' option
and in the second drop down put =A1=1 and then choose a format
colour.
Add another condition with the Add button, do the same sort of thing
with Condition 2 and put in the second drop down box =A1=2 then
choose a different format colour.
Now change A1 to 1 or 2 and observe C1 changes its format.
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|