| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional formatting based on text
Hi everyone, I've been struggling with this next request.
Is it possible to color a row with a specific color based on finding a specific word? If in row 5 the word engineer shows up I would like to turn the whole row green. No matter where in row 5 the word shows up. I've tried =IF(5:5="engineer",MOD(ROW(),2)=1,) and this works only for a word in A5. I can't seem to use A5:IV5 Any help would be appreciated. Gilles |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting based on month name | Excel Discussion (Misc queries) | |||
| Conditional Formatting of Text... | Excel Discussion (Misc queries) | |||
| Conditional formatting based on if statement. | Excel Worksheet Functions | |||
| How to do a conditional formatting based on an adjacent cell | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
