IF STATEMENT

ubiqman · May 24th, 2002, 11:10 AM

I think my problem is simple... I need to have a cell disply text in a certain when its under a certain number. I want all numbers in my column to be in red, if they are less than 3... Help...

Aladin Akyurek · May 24th, 2002, 11:13 AM

Quote:

On 2002-05-24 10:10, ubiqman wrote:
I think my problem is simple... I need to have a cell disply text in a certain when its under a certain number. I want all numbers in my column to be in red, if they are less than 3... Help...

Have a look at conditional formatting.

technix · May 24th, 2002, 11:14 AM

highlight the cells that you want to be changed to red and then goto format -> Conditional Formating and use

function is =cells<3 and select the format to be the color you want.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 24th, 2002, 11:10 AM	#1
ubiqman New Member Join Date: Apr 2002 Location: Detroit Posts: 31	I think my problem is simple... I need to have a cell disply text in a certain when its under a certain number. I want all numbers in my column to be in red, if they are less than 3... Help...

May 24th, 2002, 11:14 AM	#3
technix Board Regular Join Date: May 2002 Location: Grand Rapids, MI Posts: 326	highlight the cells that you want to be changed to red and then goto format -> Conditional Formating and use function is =cells<3 and select the format to be the color you want.