Re: Conditional Formatting

Giganews Newsgroups
Subject: Re: Conditional Formatting
Posted by:  SteveG (SteveG.27wswy_1147797901.1008@excelforum-nospam.com)
Date: Tue, 16 May 2006

Emily,

Assuming your value is in A1, in B1

=IF(A1>=30,30,A1)

HTH

Steve

--
SteveG
------------------------------------------------------------------------
SteveG's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=7571
View this thread:http://www.excelforum.com/showthread.php?threadid=542580

Replies

In response to

Conditional Formatting posted by Emily on Tue, 16 May 2006