Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
Sure, try the following...
1) Select cell A1 2) Format Conditional Formatting Formula Is 3) Enter the following formula: =(A1<"")*(A1=MAX($A1:$C1)) 4) Choose your formatting 5) Click Ok 6) Copy the format to your other cells using either the 'Format Painter' or 'Copy Paste Special Formats'. Hope this helps! In article , "Tbentsen" wrote: It sure did! Thank you very much! I would be very thankful if you could help me out with another problem: Is there a way in which you can make Excel mark the higest number in a row or column? Example: A B C 1 1 3 2 In this example, I would like the cell B3 (or the text in the cell) automatically highlighted, as it being the higest value of the three cells A1:C1 Is this possible? Best regards Thomas Bentsen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing text and returning boolean values | Excel Discussion (Misc queries) | |||
Comparing a value to a list of values does not work in Excel 2003. | Excel Worksheet Functions | |||
comparing two values | Excel Worksheet Functions | |||
Excel Comparing Values | Excel Discussion (Misc queries) | |||
Need help with lookup and comparing values | Excel Worksheet Functions |