Spreadsheet - Tick boxes & %'s - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Spreadsheet - Tick boxes & %'s

£0.00 @
Hi All, Wonder if any Excel ppl can help me with 2 things; First off, I have a spreadsheet with 6,000 users, there in a list that start in A1 and go right the way down to A3000. In B1, B2.. e…
Tanchi Avatar
7y, 9m agoPosted 7 years, 9 months ago
Hi All,

Wonder if any Excel ppl can help me with 2 things;

First off, I have a spreadsheet with 6,000 users, there in a list that start in A1 and go right the way down to A3000.

In B1, B2.. etc id like to change into a tick box. is this possible?
as in, i get to be able to tick it if i needed, not as like a tick


--

secoundly, i have a spreadsheet that gets updated daily.
if a team is performing well, there % stats gets changed to green, (below %10 - green)
between 10% and 15% they get colourd yellow, and anything over gets colourd red.

at the moment i do this manuly, is there a fourmula i can use so that the % get colourd in the right colours?

thanks
Tanchi Avatar
7y, 9m agoPosted 7 years, 9 months ago
Options

All Comments

(5) Jump to unreadPost a comment
Comments/page:
#1
Tick box - surely just Y/N in the column and use auto filter to select the items you want.

for colour format, use conditional formating from the Format menu. This will give you up to 3 (in Excel 2003) ranges to produce colours from.

Hope this helps.
#2
First part; this depends on what you want to do with the data, but yes, however I would suggest normally a 0 or 1 in the 2nd column would be more useful.

The second part is called conditional formatting.
#3
For point A, yes, the below will talk you through it: -

http://articles.techrepublic.com.com/5100-10878_11-1041101.html

For point B, use conditional formatting (Format, Conditional Formatting)
#4
pghstochaj
First part; this depends on what you want to do with the data, but yes, however I would suggest normally a 0 or 1 in the 2nd column would be more useful.

The second part is called conditional formatting.


ahh, lol i use conditional formatting all the time, didnt think! doh!

basicly this spreadsheet is going out to around 14 ppl, id like some sort of tick box next to each of the names on the spreadsheet
#5
Tanchi
ahh, lol i use conditional formatting all the time, didnt think! doh!

basicly this spreadsheet is going out to around 14 ppl, id like some sort of tick box next to each of the names on the spreadsheet


Do you want to any numbers work on the yes or no of the ticked boxes? If so, I still suggest 0 or 1, but maybe you only want it to show visually? Same with sorting etc. it just makes it easier.

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Looking for Twitter login?
Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!