shading

[Guest]

Is it possible to shade a cell from a worksheet, when that something from that cell has been slected on another worksheet. Certain range is selected in another worksheet by LOOKUP formula and DATA VALIDATION, so when an item apperasas a result of one of those reason on the next worksheet, how do I apply a shade to this cell. It is to let me know it has been selected already.

Thnx
Prakash
(e-mail address removed)

 

[Debra Dalgleish]

If you name the range on the other sheet, you can use the COUNTIF
function to check whether the value has been used.

For example, select cell B5
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type: =COUNTIF(DataEntry,B5)
where DataEntry is the named range on the other sheet
Click the Format button, and select a colour on the Patterns tab
Click OK, click OK

There are instructions here for naming a range:

http://www.contextures.com/xlNames01.html

 

[Dave Peterson]

If you only have one cell on the other worksheet (with the lookup formula), then
maybe you could use Format|conditional formatting to check to see if that cell
matches the cell in your lookup table.

But since you're using a cell from another worksheet, you'll have to use a range
name in the conditional formatting dialog.

You can read some nice notes at Debra Dalgleish's site:
http://www.contextures.com/xlCondFormat01.html