| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparison result changes font color
I want to compare 2 cells. If cell a1 is less than cell a2, then I want cell
a1 to be red. How do I do that? Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparison result changes font color
I found it: Conditional Formatting
"GScott" wrote: I want to compare 2 cells. If cell a1 is less than cell a2, then I want cell a1 to be red. How do I do that? Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparison result changes font color
Use Conditional Formatting. Select cell A1. Go to Format MenuConditional Formatting. Condition 1 should be: Box 1, Cell Value is: box 2, less than box 3, A2 Click on Format, Patterns Tab. Select the color you want to have A1 fill if the condition is true. Click OK, OK. HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=529277 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I correct uncommanded font color changes. | Excel Worksheet Functions | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
| Amount or Numbers in Words | New Users to Excel | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Hybrid Mode
