Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel
How do I bring attention to or highlight a particular cell in a column,
knowing that a different cell may need to be highlighted depending on how the data changes? For example, I have a spreadsheet, across the top are my products, along the side are issues with those products. The number of issues for a particular product may change monthly, but I want to highlight the cell which has the highest number for a particual issue at any given time, knowing that the location of the highest number may change. Help!!! |
#2
|
|||
|
|||
hey thats easy, simple u just need to mark up which product has highest no
of issues and then highlight it. u can do it by this way! Write the no of issues in a colm range, get the maximum no in that range. put conditional formatting to that range specifying the condition to return the MAX func. -- Hope it Helps! Jim India "mjiverson121" wrote in message ... How do I bring attention to or highlight a particular cell in a column, knowing that a different cell may need to be highlighted depending on how the data changes? For example, I have a spreadsheet, across the top are my products, along the side are issues with those products. The number of issues for a particular product may change monthly, but I want to highlight the cell which has the highest number for a particual issue at any given time, knowing that the location of the highest number may change. Help!!! |
#3
|
|||
|
|||
You could use conditional formatting
Under Format|Conditional Format Change the Value is dropbox to Formula is =A1 = MAX($A$1:$A$5) Range A1:A5 is formated, the max value in the range will be formatted as desired Lance "mjiverson121" wrote: How do I bring attention to or highlight a particular cell in a column, knowing that a different cell may need to be highlighted depending on how the data changes? For example, I have a spreadsheet, across the top are my products, along the side are issues with those products. The number of issues for a particular product may change monthly, but I want to highlight the cell which has the highest number for a particual issue at any given time, knowing that the location of the highest number may change. Help!!! |
#4
|
|||
|
|||
Hi
- select the range (e.g. A2:X2) - goto 'Format - Conditional Format' - choose 'Formula' and enter the following formula: =A2=MAX($A2:$X2) - chhose your format -- Regards Frank Kabel Frankfurt, Germany "mjiverson121" schrieb im Newsbeitrag ... How do I bring attention to or highlight a particular cell in a column, knowing that a different cell may need to be highlighted depending on how the data changes? For example, I have a spreadsheet, across the top are my products, along the side are issues with those products. The number of issues for a particular product may change monthly, but I want to highlight the cell which has the highest number for a particual issue at any given time, knowing that the location of the highest number may change. Help!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) |