using FILL in a formula

[waddywelsh]

I would like to automatically fill a row with a certain color based on a letter entry in the first column. EX: A in first column would automatically turn row to yellow; G in first column would automatically turn row to green, etc. Is this possible?

 

[JoeMo]

Can be done with conditional formatting. Example:
Select A1:Z1 > Home > Conditional Formatting > New Rule > Formula

Formula is:
=$A$1="A"
format with yellow fill.
Enter A in A1 and A1:Z1 will be filled with yellow interior.

 

[waddywelsh]

I typed in formula but when I pressed return, it said there was an error in the formula, but didn't tell me what.

 

[JoeMo]

I typed in formula but when I pressed return, it said there was an error in the formula, but didn't tell me what.

Instead of typing it in, copy the formula from your browser (post #2) and paste it in. The formula in that post has no error in it.