Can anyone help with conditional formatting please see below for question?

Answer 1

Sorry, I seemed to muck that up. But here is my actual question.

I am trying to use conditional formatting with 6 inputs/ coulours. I only know the basics for excel and am pretty much in way above my head.

There are two parts to this.

Firstly, canyone please give me a step by step guide of how to do the following:

Make a cell turn one of six different colours depending on which of the following is entered into the cells.

D

S

H

I know it is limited to three but now I am now trying to add

.5D

.5H

.5S

I have googled and realised that I would have to use VBA code, but when I copy and paste then try and adapt what I find it doesn't work.

thanks

Also, in the total column the formula is COUNTIF(E4:CQ4,"H") + COUNTIF(E4:CQ4,"D"). This would count the .5 entries as "1". Is there another formula that would count D as 1 and .5D as .5?

This is all a bit tricky for me, not sure if Im making sense. But Id be really grateful if anyone could help.

-------------------------------------------

the answer is

5h

6a

7h

4h