View Single Post
  #1   Report Post  
the-jackal the-jackal is offline
Junior Member
 
Location: South Woodham Ferrers, Essex
Posts: 19
Default Putting a word into a cell.

I would like to put a word into a cell depending on the value in another cell.

Example:

Cell A1=399
Cell B1=401
Cell C1=400

Cell D1= Pass or fail

So if C1 is within or equal to A1 and B1 I would like D1 to say Pass.

If C1 is outside the range of A1 and B1 I would like D1 to say Fail.

Also if its Pass I would like it to be Green text and Fail to be Red text.

Thanks in advance

Carl