| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format text Excel 2003
I am trying to Condtionally format cells that have two other numerical
condtions. I'd like the last condition to be... When typing "OK" or "ACCEPT" the cell to change green. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format text Excel 2003
=AND(condition1,condition2,OR(A1="OK",A1="Accept") )
If this post helps click Yes --------------- Jacob Skaria "Rhonda" wrote: I am trying to Condtionally format cells that have two other numerical condtions. I'd like the last condition to be... When typing "OK" or "ACCEPT" the cell to change green. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format text Excel 2003
In Conditional Formatting you can 3 formats, make sure your first two are the
other numerical conditions you mentioned below and for the third make the formula this: =OR([cell]="OK",[cell]="Accept") and then select your formatting I have tested this out so if you have issues with this method please let me know. "Rhonda" wrote: I am trying to Condtionally format cells that have two other numerical condtions. I'd like the last condition to be... When typing "OK" or "ACCEPT" the cell to change green. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 Conditional Format Color Cells Issue in SharePoint 3.0 | Excel Discussion (Misc queries) | |||
| Conditional Format Picture in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2007 Vs 2003 Conditional Format | Excel Discussion (Misc queries) | |||
| Conditional format in excel 2003 based on another cell? | Excel Discussion (Misc queries) | |||
| color coded cells and conditional format in excel 2003 | Setting up and Configuration of Excel | |||
Linear Mode
