answersLogoWhite

0

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

User Avatar

Wiki User

9y ago

What else can I help you with?

Related Questions

How do you specify that the cells selected range whose value is greater than 5 in excel?

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.


If the value of the cell changes and no longer meets the specified condition will Excel suppresses the conditional formatting?

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.


I need help setting up a crossword on Microsoft Excel?

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?


If you get a conditional discharge do you have a criminal record?

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.


Why hasn't anyone answered my question can someone answer it please?

whats your question ?


Does he killed a dog?

I am not sure anyone will get the question. Please post another question and take your time.


Does the quickfire have a slot or space for a charm?

can anyone give me an answer to this question... please!!


Please anyone tell me the answers?

I would try if you told me the question.


Can anyone please tell you creating a group of any Hotel Brand on Facebook is illegal or copyright please reply?

why would anyone reply? dumb question!


What was characteristic of the performances of the Rolling Stones?

PLEASE CAN ANYONE ANSWER THIS QUESTION ?ITS VERY IMPORTANT !


Is there anyone sued by Meris law office due to success unlimited enterprises books?

I really need someone to answer this question........... please.....please.....please.........


How does Theo feel after spying on Otis and Crow at the soup kitchen?

Can anyone answer this question please