Remember Me?

#1
December 31st 05, 07:29 AM posted to microsoft.public.excel.misc
 OSCAR Posts: n/a
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
December 31st 05, 07:39 AM posted to microsoft.public.excel.misc
 Peo Sjoblom Posts: n/a
If formulation: Is it possible...

in B1 put

=A1

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

--
Regards,

Peo Sjoblom

"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
December 31st 05, 07:52 AM posted to microsoft.public.excel.misc
 OSCAR Posts: n/a
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

"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
December 31st 05, 08:53 AM posted to microsoft.public.excel.misc
 Biff Posts: n/a
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

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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post OSCAR Excel Discussion (Misc queries) 2 December 31st 05 07:06 AM croberts New Users to Excel 1 October 7th 05 06:30 PM [email protected] Excel Worksheet Functions 0 September 6th 05 09:36 PM LGrobe Excel Discussion (Misc queries) 1 August 16th 05 06:23 PM lashio Excel Discussion (Misc queries) 3 June 15th 05 01:15 PM

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