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 |
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 |