General discussion

Locked

display text if certain condition is met

By bnagy ·
i have a column of numbes in column A in microsoft excel 2000. if the number value in each cell is greater than 120, then i want the text "Follow Up" to display in column 2 directly to the right of the number. what is the formula to achieve this?

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

display text if certain condition is met

by timwalsh In reply to display text if certain c ...

=IF(A1>120,"Follow Up"," ")

Copy and past to all required cells in column B. It will automatically adjust the cell reference (A1) to match the appropriate cell.

Collapse -

display text if certain condition is met

by bnagy In reply to display text if certain c ...

Poster rated this answer

Collapse -

display text if certain condition is met

by DKlippert In reply to display text if certain c ...

You might also want to look at Conditional formatting.
Select the column. Go to Format>Conditional Formating.
Choose If cell value is greater 120
and then choose the Format for the cell, color of the font, cell background etc.

Collapse -

display text if certain condition is met

by bnagy In reply to display text if certain c ...

Poster rated this answer

Collapse -

display text if certain condition is met

by bnagy In reply to display text if certain c ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Forums