| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Certain Words
I have an excel sheet that lists members of a department. Next to their name
in column B they need to put yes, no or maybe. As they type their answer I would like yes to be red, no to go blue and maybe to go green. Can you format cells based on what answer they put in the cell? So as yes is typed the word goes to red? Thanks, Shane |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting Certain Words
Use Conditional Formatting:
Format Conditional formatting Formula is: =A1="yes" and pick a red font repeat for blue and green. -- Gary''s Student - gsnu200722 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting for specific words in cell | Excel Discussion (Misc queries) | |||
| conditional formatting -- testing for multiple words | Excel Discussion (Misc queries) | |||
| conditional formatting on words | Excel Discussion (Misc queries) | |||
| conditional formatting for cells containing words | Excel Discussion (Misc queries) | |||
| how do i insert words into a column without erasing the words | Excel Discussion (Misc queries) | |||
Linear Mode
