light

Hi All, So i need some help, i am stuck on this, Basically i have a spreadsheet where i have formatted the columns to go light green if i type a "y" in the field. What i need help with is how to change another field so that if the other field says y then i also want that field to turn light...

I have two needs for red, yellow, green stop lights 1) if cell A1 has "05" (as text), then cell A2 should be a green light. If it has "03" (as text), then cell A2 should be a yellow light. If it has "02" (as text), then cell A2 should have a red light. 2) if cell A3 has a date between...

Hello, I have some trouble solving the following exercise: In column M on the worksheet ‘Purchase Invoices’ use an appropriate lookup function based on thedescription, together with an appropriate logical formula to show whether the supplier for eachinvoice is on the approved supplier list. The...

I wonder if some one has a tip on how to solve this conditional type formatting problem. I want to color each cell based on if the value has increased or decreased from the value immediately below. If the value is following a trend the color will get darker, so based on the values of column B...

Hi... Pls help me with the following.... A LED light producer tested the life of 30 samples. The question asked to find minimum and maximum LED light life by using spreadsheet formula, which I did. Then, I am stuck when it asked to Find the percentage of LED lights which have less than mean life.

Hi, I have a worksheet that I want to apply conditional formatting to. The condition is that if there is a "Yes" in a cell in column G, that particular row from column A to G would be highlighted in light green. Is there a way to do this without using VBA? If not, could someone in the Forum...

Hi I highlighted multiple cells, then I entered a simple formula in the first cell (light color cell) and pressed ctr+enter, so I can copy the same formula over all cells. It did work fine. Now If I want to change/edit the formula in the first cell (which was light color), how can I do the same...

Hello everyone, This is a very practical exercise that I am trying to do since a little while but without any success. I defined 2 informations for light bulbs : - The 1st time it is likely to burn and be replaced : For example after 2.5 years or after 0.3 year - The life time of a bulb : For...