#1   Report Post  
Old December 31st 05, 06:10 AM posted to microsoft.public.excel.misc
OSCAR
 
Posts: n/a
Default If formulation

what would be the formula for cell A1 thru A10 equaling more than 40.00 the
result turns red?

  #2   Report Post  
Old December 31st 05, 06:59 AM posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default If formulation

If you mean any cell in the range A1:A10 is greater than 40.00? Select
A1:A10, do formatconditional formatting
cell value is greater than 40, click format and select red fonts and click
OK twice

If you mean the sum of A1:A40? Select the cell with the formula =SUM(A1:A10)
do the same formatting

--
Regards,

Peo Sjoblom

(No private emails please)


"OSCAR" wrote in message
...
what would be the formula for cell A1 thru A10 equaling more than 40.00
the
result turns red?


  #3   Report Post  
Old December 31st 05, 07:06 AM posted to microsoft.public.excel.misc
Vito
 
Posts: n/a
Default If formulation


Select cells A1 through A10.

Then Select Conditional Formatting from the Format Menu.

Select Is Greater Than from the middle drop down and enter 40 in the
right drop down.

Then click Format, select colour from the Font Tab.

Then Click Ok twice.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=497109



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formulation of an expiry summary croberts New Users to Excel 1 October 7th 05 06:30 PM
Multi - Level Question involving Data Mapping and Formulation [email protected] Excel Worksheet Functions 0 September 6th 05 09:36 PM
Time formulation? LGrobe Excel Discussion (Misc queries) 1 August 16th 05 06:23 PM
Simple Slope Formulation lashio Excel Discussion (Misc queries) 3 June 15th 05 01:15 PM
cell in cell formulation possible??? Abi Excel Discussion (Misc queries) 4 January 7th 05 08:13 PM


All times are GMT +1. The time now is 07:35 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017