Help with EXCEL

News items and topics not related to baiting.
Post Reply
User avatar
crashhoot
Moderator
Posts: 1024
Joined: Mon Feb 17, 2020 11:58 pm
Location: Looking for the petting zoo.
Original Eater Join Date: 08 Aug 2004

Help with EXCEL

Post by crashhoot » Wed Jun 15, 2022 11:26 pm

Any EXCEL spreadsheet experts out there?
I need help with either formatting or formulas, not sure which.

I track my 401K accounts by placing the daily value in descending cells of a column, then use that column as the source for a graph; works fine.
However, is there a way for EXCEL to automatically highlight the cell with the highest value in that column (change color, italicize, bold face, etc.)?

Any help would be appreciated.
Mr Jokers are you still alive,happy new year to you. Festus Keyamo

:mortar: x27 :tvstar::pbear: :$_lad: x2
[Click here to support 419Eater.com]
"Do you have any goat porn?" SamV, Las Vegas, 2006
Mark Time, RIP

Armageddon!

User avatar
B8er
Associate
Posts: 415
Joined: Tue Feb 18, 2020 3:20 am
Location: Here, or maybe there
Original Eater Join Date: 16 Feb 2009

Re: Help with EXCEL

Post by B8er » Thu Jun 16, 2022 2:22 am

Its been a while since I used it, but there is an option in conditional formatting that allows you to highlight the highest value in a range of cells, you should be able to use that on an entire column and it will update as you enter new values.

This page explains it well https://www.exceldemy.com/highlight-hig ... -in-excel/ - method 1 is the one you want
👅🌺🌋😅

User avatar
Kitty La Gore
Old Mod
Posts: 1876
Joined: Mon Feb 17, 2020 9:12 pm
Location:
Original Eater Join Date: 03 Feb 2014
Contact:

Re: Help with EXCEL

Post by Kitty La Gore » Thu Jun 16, 2022 4:21 am

^^ yup, what B8er said. I use it to track my finances as well, and I use conditional formatting to show whether investments are gaining or declining year over year (my style is more DCA or long-term indices rather than day trading). With the market doing what it is this year, I have a sea of red on the charts with only a few minor areas of green, so I know it's working :roll: . I used to teach Excel courses, but that was back in '00 - '07 or so, and I think we still had Clippy around...

If you want to simply track a maximum number within a range (eg., "what year was my highest level of income between 2010 and 2022?") you could put this formula into a cell: =MAX(A10:A22) where A10 represents the first year in the series, and A22 represents the last year. The highest number will appear in the cell with the formula. You can also create a running daily percentage for increases or decreases with the formula =1-A11/A12 -- put that formula in a cell to the right of your list, starting at A12 (or whichever cell is second to avoid division by 0) and then format it as a percentage. Drag the formula copy handle down your list for a daily percentage of increase or decrease.

I was tracking stolen credit card numbers in excel for a bit with one of our black pork baits and had some fun randomizing credit card rejection notifications along columns of submitted card numbers. I also tracked the amount of money the lad attempted over 7 characters of mine (7 tabs in the spreadsheet) and then kept a running grand total on a final page from the other 7 tabs. He attempted something like $200k over 6 months time.

Excel is awesome!
I'm really scared because I notice that I'm develop malaria because of the hot climax here ~ Abiola in Rosso
i was kidnap by Nigeria North desperate danger men in Borno state Nigeria all because of u ~Tim (8 yr anniversary in May '22)
You are been a foolish man with a naughty brain. ~Paul K
Abiola-Tim: Lagos to Dakkar to Rosso (wDSW) 7 yrs (anniversary 5/27) | 5 yrs ~ Paul K
Am just tired and confused and the cards didn't work. ~Jeff

User avatar
crashhoot
Moderator
Posts: 1024
Joined: Mon Feb 17, 2020 11:58 pm
Location: Looking for the petting zoo.
Original Eater Join Date: 08 Aug 2004

Re: Help with EXCEL

Post by crashhoot » Thu Jun 16, 2022 11:55 pm

@ B8er. Yes that's exactly what I wanted. Forgot to mention, though, that I'm using an ancient version of EXCEL and that option is not available for cell formatting. However, Kitty's use of MAX might help me do a workaround.

@ Kitty. I like your idea for a running daily percentages. That was a problem that I gave up on a long time ago!

Thanks both for your help.
Mr Jokers are you still alive,happy new year to you. Festus Keyamo

:mortar: x27 :tvstar::pbear: :$_lad: x2
[Click here to support 419Eater.com]
"Do you have any goat porn?" SamV, Las Vegas, 2006
Mark Time, RIP

Armageddon!

User avatar
Kitty La Gore
Old Mod
Posts: 1876
Joined: Mon Feb 17, 2020 9:12 pm
Location:
Original Eater Join Date: 03 Feb 2014
Contact:

Re: Help with EXCEL

Post by Kitty La Gore » Fri Jun 17, 2022 12:28 am

^^ You're welcome for the EXCEL help, but I wish you even better luck in this bear market :shock:
I'm really scared because I notice that I'm develop malaria because of the hot climax here ~ Abiola in Rosso
i was kidnap by Nigeria North desperate danger men in Borno state Nigeria all because of u ~Tim (8 yr anniversary in May '22)
You are been a foolish man with a naughty brain. ~Paul K
Abiola-Tim: Lagos to Dakkar to Rosso (wDSW) 7 yrs (anniversary 5/27) | 5 yrs ~ Paul K
Am just tired and confused and the cards didn't work. ~Jeff

User avatar
bware419ers
Forum Admin
Posts: 1368
Joined: Mon Feb 17, 2020 8:38 pm
Location: At the bank
Original Eater Join Date: 25 Jun 2012

Re: Help with EXCEL

Post by bware419ers » Sat Jun 18, 2022 12:45 pm

I heard someone say it best the other day: "You haven't lost anything unless you've sold."
REPORT BANK ACCOUNTS | FOLLOW 419EATER ON TWITTER

RIP "FFS." - Capone
RIP Toomuchfun
RIP Irishemigrant
"I started to read it but got bored after the first couple of sentences." - SOOI
"Remind me not to get on your bad side." - jose_cuervo

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests