Why don't you just use the
* Menu - Format - Conditional Formatting and
* set "Cell value is" "equal" "A"
* Hit the format button and choose whatever text/cell formatting you want

"haifa" wrote:

Does anyone know how I can shade certain cells in by typing in a letter or
number, using If statements?