| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If/Then formatting
Novice here
I would like to highlight/color a cell if the number of that cell exceeds the number of the cell next to it. The cell I would like to color already has a formula for adding in it. Any help is greatly appreciated John |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then formatting
Here is an example for B1. If B1 is greater than A1, we want B1 highlighted:
Click on B1 and: Format Conditional Formatting... . Formula Is =B1A1 and then pick a nice color. -- Gary''s Student - gsnu200772 "John" wrote: Novice here I would like to highlight/color a cell if the number of that cell exceeds the number of the cell next to it. The cell I would like to color already has a formula for adding in it. Any help is greatly appreciated John |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If/Then formatting
HI John
Go to ' Format/Conditional Formatting/ select "Greater Than or your choice and next window select the cell reference eg: =A2 Regards Cimjet "John" wrote in message ... Novice here I would like to highlight/color a cell if the number of that cell exceeds the number of the cell next to it. The cell I would like to color already has a formula for adding in it. Any help is greatly appreciated John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
| Pivot Table border formatting and pivot chart formatting | Excel Discussion (Misc queries) | |||
Linear Mode
