Software

Ask something
Discussion Locked

display text if certain condition is met

0 helpful
5 replies

by bnagy

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

5 replies

by timwalsh

=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.

by dklippert

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.

This discussion is closed to new replies.