Need help

[jeff7188]

I need some help. I have a spreadsheet Attendance 2022 . It turns colors correctly but I'm having a problem with getting the letter to change. Example I have it turn red when a p is entered in. I need to have it on another tab called points

ts each letter stands for a different point level. And i need it to total it . The x should total 3 points for each time an x is there Any help would be appreciated.

 

[ExceLoki]

here's a simple solution for you. in it you can give each letter code a value
---------------

Book1
	A	B	C	D	E	F	G	H	I	J
2	10.5		l	p	p	x	x	x	p	p
3	18		x	x	x	x	x	x	x	p
4	3		p	l	p	p	l	p	p	p
5	4.5		p	p	l	p	p	p	p	x
6	9		p	p	x	p	x	p	x	p
7	12		p	x	p	x	p	x	p	x
Sheet1

Cell Formulas
Range	Formula
A2:A7	A2	=SUM(COUNTIF(C2:K2,"x")*3,COUNTIF(C2:K2,"l")*1.5)

 

[jdellasala]

Assuming you only have a short list of items you want allowed in those cells, set them up using a Data Validation list.
Go to the Data tab, at the bottom of the Data Tools section select Data Validation. It looks like the values you're using are "l, p, x, exec". That's the most direct, but would require setting the entire row of input cells like that - which you can do by selecting them first.
The other way would be to adjust your conditional format formula (assuming you're using that), and use something like "=SEARCH(D$3,"p")" which would return true for either "P" or "p" as SEARCH is NOT case sensitive.
Personally I'd go with the Data Validation option to keep the data consistent.

 

[jeff7188]

Thank you