I was playing with conditional formating and useing the following was able to make my green cells turn red.
condition one
cell value is equal to E2 (holding cell)
format red
With overdue in E2 when I type overdue into my formated cells they turn red
condition two
cell value is between 1 to 1000
format green
My cells are green with any number between 1 and 1000
if I have a green cell and i type in overdue it now turns red.
Hope this helped.........
Denny
Like this thread? Share it with others