Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add differnt font colors to Formula results
I'm using this formula-
=LARGE(E3:E26,1) And all is working great but I want it to also highlight the number in (E3:E26) Basically I have a list of numbers and the LARGE formula below but I want to also have it highlited in the list it came from. I think I probably have to have a whole new formula to do that seperate from the LARGE forumula. What I am doing is tracking the charge of my RC car AAA batteries. I have 24 batteries total and the cars run on sets of for so 6 sets total. I've created 6 different sets of LARGE formulas by MAH. So no I have identified which sets are matched best but it only display by MAH and I have to refer back to the list and find the corresponding letters. I'd like to be able to just see them grouped by color so is there a formula for that? Thanks! Kris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add differnt font colors to Formula results
Have a look at Format | Conditional Formatting
Come back if you need help with it best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Mini-zKris" wrote in message ... I'm using this formula- =LARGE(E3:E26,1) And all is working great but I want it to also highlight the number in (E3:E26) Basically I have a list of numbers and the LARGE formula below but I want to also have it highlited in the list it came from. I think I probably have to have a whole new formula to do that seperate from the LARGE forumula. What I am doing is tracking the charge of my RC car AAA batteries. I have 24 batteries total and the cars run on sets of for so 6 sets total. I've created 6 different sets of LARGE formulas by MAH. So no I have identified which sets are matched best but it only display by MAH and I have to refer back to the list and find the corresponding letters. I'd like to be able to just see them grouped by color so is there a formula for that? Thanks! Kris |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add differnt font colors to Formula results
Yeah I found that after I posted up but it only allows up to 3 conditions. I
needed 6 so I think I'm trying to do something with the wrong formula. I did however manage to get a good enough result for what I'm trying to accomplish. Next thing I need is to get the last inputed number to make it auto sort descending...Thanks for your help. Regards, Kris "Bernard Liengme" wrote: Have a look at Format | Conditional Formatting Come back if you need help with it best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Mini-zKris" wrote in message ... I'm using this formula- =LARGE(E3:E26,1) And all is working great but I want it to also highlight the number in (E3:E26) Basically I have a list of numbers and the LARGE formula below but I want to also have it highlited in the list it came from. I think I probably have to have a whole new formula to do that seperate from the LARGE forumula. What I am doing is tracking the charge of my RC car AAA batteries. I have 24 batteries total and the cars run on sets of for so 6 sets total. I've created 6 different sets of LARGE formulas by MAH. So no I have identified which sets are matched best but it only display by MAH and I have to refer back to the list and find the corresponding letters. I'd like to be able to just see them grouped by color so is there a formula for that? Thanks! Kris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing font colors... | New Users to Excel | |||
Font Colors | Setting up and Configuration of Excel | |||
Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) | |||
How do I display negative numbers in a differnt color font? | Excel Discussion (Misc queries) | |||
Formula results in font color change | Excel Worksheet Functions |