| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formating
I wonder if anyone can help me please
I'm trying to set up conditional formatting for a cell based on data in range of cells for example: cell D9 should turn red if E9:Q9 contains letter a I have been trying using find but no luck so far. thanks -- Afia |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formating
Use the option FORMULA IS in Conditional Formatting and enter the formula
=COUNTIF(E9:Q9,"a") "Afia" wrote: I wonder if anyone can help me please I'm trying to set up conditional formatting for a cell based on data in range of cells for example: cell D9 should turn red if E9:Q9 contains letter a I have been trying using find but no luck so far. thanks -- Afia |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formating | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| Conditional Formating | Excel Worksheet Functions | |||
| Help Please with Conditional FOrmating | Excel Worksheet Functions | |||
| In conditional formating, is it possible to do? | Excel Discussion (Misc queries) | |||
Linear Mode
