title: VBA for changing font and colour of a cell if a certain word is typed in it
body: <p>I have a somewhat large spreadsheet with a type of summary page that follows a calender layout. </p>
  
  <p>On this page I manually change the font and color of cells to make it easy for me to find certain things on it. For example, (I lecture mathematics) if I have revision on a certain lesson, I make that cell bold and green. (exact type of green I can sort out myself). I want a VBA code if possible so that if I type the word revision into a cell on that sheet only, not whole workbook, that it would automatically change it to green. </p>
  
  <p>Realistically, I don't manually type in the word revision always. Some of it uses lookups of various types to find what happens on that day to display a word (for example revision) in that given cell.                                         </p>
  
  <p>I don't know if this is possible to do. I realize that if "revision" is shown due to a lookup then the contents of that cell is not equal to "revision" but a formula which simply displays "revision"</p>
  
  <p>Any assistance would be appreciated. If I have a basic code I can manipulate to get it right.</p>
  
  <p>Thanks</p>