That works...I didnt know this cool feature....Thanks Dave Peterson and Dave O

"Dave O" wrote:

You can apply conditional formatting to do this: in cell B1, for
instance, click Format Conditional Formatting; set condition 1 to
Formula Is and enter
=$A$1="F"
in the formula box; then choose the color you want to show for failed
entries.