| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting Minimum value
I have two colums of values. I need the value in column A highlighted
whenever it is greater than the corresponding value in column B. I'm not having a problem doing that for a particular cell through conditional formatting, but I can't seem to get ti to appy to the whole column. Help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlighting Minimum value
Highlight column A, and select Conditional Formatting
Change cell value is to Formula Is and then type in the formula =$A1$B1 Make sure to include the $ signs. "Lgirl" wrote: I have two colums of values. I need the value in column A highlighted whenever it is greater than the corresponding value in column B. I'm not having a problem doing that for a particular cell through conditional formatting, but I can't seem to get ti to appy to the whole column. Help? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Highlighting Minimum value
IT WORKED!
Thank you so much! "akphidelt" wrote: Highlight column A, and select Conditional Formatting Change cell value is to Formula Is and then type in the formula =$A1$B1 Make sure to include the $ signs. "Lgirl" wrote: I have two colums of values. I need the value in column A highlighted whenever it is greater than the corresponding value in column B. I'm not having a problem doing that for a particular cell through conditional formatting, but I can't seem to get ti to appy to the whole column. Help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| minimum and the corresponding value | Excel Worksheet Functions | |||
| How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
| minimum | Excel Worksheet Functions | |||
| Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
| Minimum Value | Excel Worksheet Functions | |||
Hybrid Mode
