Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
OSCAR
 
Posts: n/a
Default If formulation: Is it possible...

That if a value is greater than 40.00 in a particular cell, that the value
greater than 40.00 show up in another cell in a different color?

for example if A1 cell value is 41.75, then B1 cell will show 1.75 in red.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default If formulation: Is it possible...

in B1 put

=A1

then select B1, do formatconditional formatting, cell value greater than
40

--
Regards,

Peo Sjoblom

(No private emails please)


"OSCAR" wrote in message
...
That if a value is greater than 40.00 in a particular cell, that the value
greater than 40.00 show up in another cell in a different color?

for example if A1 cell value is 41.75, then B1 cell will show 1.75 in red.


  #3   Report Post  
Posted to microsoft.public.excel.misc
OSCAR
 
Posts: n/a
Default If formulation: Is it possible...

tHAT DIDNT WORK. i WOULD LIKE THE CELL TO SHOW THE GREATER VALUE ONLY.

"Peo Sjoblom" wrote:

in B1 put

=A1

then select B1, do formatconditional formatting, cell value greater than
40

--
Regards,

Peo Sjoblom

(No private emails please)


"OSCAR" wrote in message
...
That if a value is greater than 40.00 in a particular cell, that the value
greater than 40.00 show up in another cell in a different color?

for example if A1 cell value is 41.75, then B1 cell will show 1.75 in red.



  #4   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default If formulation: Is it possible...

Hi!

A1 = 41.75

Enter this formula in B1:

=IF(A140,A1-40,"")

Select cell B1
Goto FormatConditional Formatting
Select: Formula Is
Enter this formula in the box:

=LEN(B1)

Click the Format button
Select the style(s) desired
OK out

Biff

"OSCAR" wrote in message
...
tHAT DIDNT WORK. i WOULD LIKE THE CELL TO SHOW THE GREATER VALUE ONLY.

"Peo Sjoblom" wrote:

in B1 put

=A1

then select B1, do formatconditional formatting, cell value greater
than
40

--
Regards,

Peo Sjoblom

(No private emails please)


"OSCAR" wrote in message
...
That if a value is greater than 40.00 in a particular cell, that the
value
greater than 40.00 show up in another cell in a different color?

for example if A1 cell value is 41.75, then B1 cell will show 1.75 in
red.





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
If formulation OSCAR Excel Discussion (Misc queries) 2 December 31st 05 07:06 AM
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


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

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

About Us

"It's about Microsoft Excel"