Changing Cell Value Based on Another Cells

[LiamPoll]

Im sorry if there is already a thread covering this and/or i have not posted it in the right area.

Im currently completing an assignment for my boss using Excel 2007.
I am creating a document to be completed by others containing results of a certain kind.

In cell B13 i have conditional formatting for numbers (Highlight cell rule, Between)
I then want cell C13 to input/change the txt automatically when B13's value changes

For instance if B13 had 100-139 the cell would turn red. However when it turns red i want c13 to have ACTION REQUIRED show up.

Also example if B13's value is between 50-90 the cell will be conditionally formatted to change green. When this cell changes green i want cell C13 to say NO ACTION REQUIRED automatically show up

Help would be much appreciated
Thanks Liam

Moved to Calc – Robert Tucker, Moderator

[Robert Tucker]

[Jezzta667]

Hi,

I'm no calc genius but I would use a VLOOKUP

Write a list somewhere (anywhere out of the way) that has two columns like this:

0
50 NO ACTION REQUIRED
90 NO ACTION REQUIRED
90.01
100 ACTION REQUIRED
139 ACTION REQUIRED
139.01

Let's say A1 has the data and B1 is the cell you want to display the message, change the formula in B1 to:

=VLOOKUP(A1;(select the whole two columns as written above;2;0)

Someone who is better than me can correct me or give a better solution but VLOOKUPS are great for this sort of thing.