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
I do not understand what is being asked here. If it is a question about conditional formatting, then please ask another question specifically related to conditional formatting. If it is not related to conditional formatting, then perhaps you could clarify in the discussion section.
Conditional formatting means that a cell will be formatted differently based on values. So when values change, the formatting may changed. Formatting will not be suppressed, just changed, which is the whole point of conditional formatting.
Question cont..... Ok so I have the basics sorted, what i need help with is the conditional formatting. I want to format each answer so that the whole word needs to be correct before it will change the shading to indicate a correct answer. I know how to do the basic formatting where each letter changes shading if correct. Anyone that can help please?
Not enough info on the "conditional discharge." Is the question referring to a militarydischarge? If so, what was the underlying reasons for it? More info please and re-word and re-submit the question.
whats your question ?
I am not sure anyone will get the question. Please post another question and take your time.
can anyone give me an answer to this question... please!!
I would try if you told me the question.
why would anyone reply? dumb question!
PLEASE CAN ANYONE ANSWER THIS QUESTION ?ITS VERY IMPORTANT !
I really need someone to answer this question........... please.....please.....please.........
Can anyone answer this question please