If sum>= 60, color cells red

Hello,

I want a cell to change color if another cell contains the words "first aid". The text comes down from a drop down list and could read "First Aid" or "sleepover/first aid".

If the cell has "first aid" in it, I want the other cell to change color. I can get it to work if using formula f13=first aid but it won't change color if the cell says sleepover/first aid?

Can anyone help?

hi, wanted to check if it's possible to do condition formatting on cell color based on another cell's text.

For example I have cell A1 with Text Pass. Cell A1 already has conditional formatting for text "PASS" = cell color green, and text "FAIL" = cell color red. On the other hand, I have cell A2 which has some details in it and already contains a formula. I want to base A2's cell color with A1. If A1 = PASS and A1 cell color is green, then A2 cell color will be Green too. If A1 = FAIL and A1 cell color is Red, the A2 will cell color will be Red too.

Hope the description is not complicated. Thanks in advance for any advice given.

Hi,
I am trying to change the colour of a range of cells within a row if I choose an option from a drop down box within the same row and cell range. The cells in the row need to change to a different colour should the selection in the dropdown box change.

e.g. cell range A5:H5 to be red if C5 = declined, or green if C5=won

I also require the same formatting to rows 6 downwards

Any help would be appreciated

Jim

Hello,

I have "text" in cell B1. However, I want the font color to change based on the numerical value in cell B8; so if the number in cell B8 ranges between 1-10, I want the text in B1 to change to GREEN; if the number in B8 ranges 11-20, I want the text in B1 to change to BLUE; if the number in B8 is greater than 20, I want the text in B1 to change to RED.

Is this possible?

Thank you so much!

Hello,

I am relatively new to VB and I am trying to help a friend build an application form for work. Basically what I am trying to do is, there are 6 cells which need to be filled out (name, address etc) in this form on excel before printing will be allowed. There is a 'print' button to the left of the form and when it is pressed it would be great to have the cells that should be filled out, to highlight and have a message box pop up stating that fields have not been completed. Does anyone know how to do this? It would be so awesome of you.

Benji

Configuration: Windows XP / Safari 533.4

Hello all,

I am trying to speed up a task which I have do it manually with VBA:

There is a table like below"

Date;Name;ID;Text
20120101;Peter;00001;ABTC
20120102;May;00002;DdfEF
20120102;Jane;00002;GHIRTE
20120204;Larry;00003;qweR
20120506;Larry;00004;klnfdg
20120506;Tom;00004;ewrwrk
20120506;Ray;00004;sdfff
20120506;Ron;00005;kkkk


What I need to do is to merge adaject rows whenever they contain the same ID, resulting:

Date;Name;ID;Text
20120101;Peter;00001;ABTC
20120102;May;00002;DdfEF
20120102;Jane;*M...