| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting based on text in another cell
Hi,
I want to CF the cell A1 based on a text value in Cell F1 Do I just use the CF formula $F1=Cancelled Cancelled being the test, if true I want A1 formatted? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting based on text in another cell
Hi,
Select A1, then go to Format/Conditional formatting, change to Formula Is, and enter =f1="cancelled" then apply the formatting you want. You must include the quotes around a text string. Dave "Dave Eade" wrote: Hi, I want to CF the cell A1 based on a text value in Cell F1 Do I just use the CF formula $F1=Cancelled Cancelled being the test, if true I want A1 formatted? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting based off cell with text? (i.e. "less than | Excel Discussion (Misc queries) | |||
| Conditional formatting Based on cell A text with conditions in Cell B | Excel Discussion (Misc queries) | |||
| Conditional Formatting based on text? | Excel Worksheet Functions | |||
| Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
| Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
Linear Mode
