shading

P

Prakash

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
[email protected]
 
D

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
 
D

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
 
Top