color cells based

Dear All, I require a formula to count the respective colours for each employee as below:

I have below formula in one cell, lets take example A10 =VLOOKUP($A$2,'Port-3-Script'!$A$3:$DW$1992,95,FALSE) in above formula it copies value from cell CE from Port-3-Script, as 95th column is mentioned in formula Please help me in getting solution of below problem 1. I want along with values...

The code is getting to blurry for a yellow belt exceller as myself. I keep getting wrong values and #####...:confused: Basically I am trying to make the cells in the column ”level” to mark the cell green when the user for example puts in the correct level value (if it matches the value in the...

Hello, I am hoping someone can help me figure this one out. I have a sheet with a list of numbers on it (numbers can be 1-50): Example: <tbody> 1 2 3 2 2 3 2 2 1 3 1 2 1 1 2 </tbody> and another sheet in the same workbook which I have set with COUNTIF to count the number of times a...

So i did a HLOOKUP in comparing two table columns. The Hlookup came back with errors for data that didnt match the table column names. Is there a way for me to highlight the cells in C2 if Cell A2 has #N/A in it?

I need to look up a range (BE4:BE2383) and if the cells read "Pass" I want it Green if the cells read "Fail" I want it Red. How can I automate this?

Hi All, I have a query please. I want to color the cells for some specific texts in RED, and some in BLUE and some in GREEN. For Eg: I want to color the cells in RED, which contains below specific texts in a sheet. UNIX LINUX MS OFFICE POWER...

I have a gantt chart that was built in excel. I need to shade cells in the timeline based on persons title under each project. I can provide a snip of what the layout looks like for a better visual. I want the PM's Green, Supers Yellow and Persons Reporting Orange. To get the green bar shown...

<o:smarttagtype namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="City"></o:smarttagtype><o:smarttagtype namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"></o:smarttagtype><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom>...

Hello, I am new to this forum, and have looked around but have not seen a post quite like this. I am temping at an office that is preparing a huge budget planning spreadsheet. My client extracted data from Access, prepared a pivot table, highlighted subtotals at various levels with different...

Here is the code I am using to select a value and change the color of the target, however the target I want to change the color of is the cell immediately to the right of the select case value. For example, if the cell value in A1 is equal to cake, then B1 needs the cell color to change...

<TABLE style="WIDTH: 352pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=469 border=0 x:str><COLGROUP><COL style="WIDTH: 48pt" span=4 width=64><COL style="WIDTH: 64pt; mso-width-source: userset; mso-width-alt: 3108" width=85><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR...