Hi,
I need help figuring out a formula that will change the colour of a cell to red if a letter "I" is entered, or green if a letter "A" is entered. I also need the formula to calculate the total number of "A"s that have been entered for a particular row and the total number of "I"s for a particular row. I've attached an image which may help. Conditional formatting.PNG
Thank you in advance!
Bookmarks