color cells based

  1. H

    Excel color formula

    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...
  2. E

    Mark cells in color pending on correct/incorrect 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...
  3. G

    Conditional Formatting based on another cell's value ... trying to make like a heat map of numbers

    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...
  4. S

    Need Help with Conditional Format

    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?
  5. A

    How can I fill certain cells with color depending on what info is inside?

    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?
  6. S

    How to color cells for some specific texts in an excel sheet

    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...
  7. P

    Conditional Formatting: How to shade cells based on meeting 2 criteria NEED HELP ASAP

    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...
  8. S

    Autofill cell based on other cell data

    <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>...
  9. A

    Can I autosum cells between colored rows?

    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...
  10. D

    Trying to input an offset.

    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...
  11. P

    Counting Cells and color coding

    <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...

Some videos you may like

This Week's Hot Topics