Excel Selection

[Dolby]

HI,

I've got an Excel sheet containing new deals at work. Currently, I highligh the closed/sealed deals in green. This works great - cept when people print the sheet in b/w they can't see the green.

Now I can add an extra column saying 'closed' with 'X' next to each - or I can create a tick, option box or something. The latter is cooler

How can add something like this?

 

[Dr.G]

Looking for a Cool way to do it are we
Haha why not just Create the template with and extra collumn for ticking in, Print it and Tick
But to answer your question sorry i dont have an answer

 

[DJ...]

I think one of the wingdings fonts has a tick in its alphabet You could set up conditional formatting so that if that cell = tick, then it will highlight the cell green still.

 

[DJ...]

Or just create a list containing "closed, open" and set data validation on the specific cells so that they can only be from that list, ie: closed/open. Or set the list to equal "tick" (wingdings actual tick) or something like "-" (as setting it to blank will be fruitless) then you can select the tick from the drop down on each cell instead of having to change fonts every time

 

[remybfg10k]

my brain is a bit sore but:

use an IF statement, something like =IF(A1="green",X)

a conditional format type situation might be better for you

 

[DJ...]

my brain is a bit sore but:

use an IF statement, something like =IF(A1="green",X)

a conditional format type situation might be better for you

That wont work AFAIK. If statements wont work on the format of the cell. That would only work if the actual cell had the word "green" in it...

 

[remybfg10k]

i know that, just putting him in the right direction

I know there was a macro/vb script called WotColour.xls that i found that would basically do the cell colour results thing

 

[charlie_82]

HI,

I've got an Excel sheet containing new deals at work. Currently, I highligh the closed/sealed deals in green. This works great - cept when people print the sheet in b/w they can't see the green.

Now I can add an extra column saying 'closed' with 'X' next to each - or I can create a tick, option box or something. The latter is cooler

How can add something like this?

What version of Excel are you using? Cos Excel 2007 will read formatting in IF statements

 

[eitai2001]

Use Marlett ... then type B for a tick and type R for an X.

 

[Flipside]

you can use checkboxes if theres not alot of rows
http://articles.techrepublic.com.com/5100-10878_11-1041101.html

or else like the others mentioned, just use validation.

 

[remybfg10k]

charlie_82 got an example for me, using 2007 but havent come across it yet?

 

[charlie_82]

sorry my bad, it won't work on the IF statement. but it will sort by font color, cell color etc.
sorry

 

[HavocXphere]

Cell shading usually prints out nicely.

 

[dequadin]

Cell shading usually prints out nicely.

+1 to this. Black background with white text (or similar) will work nicely...