Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 21
Default Problems with Conditional Formatting in Excel 2007

Hi,
I am having trouble getting values in my conditional formatting to hold
properly. I am using a Icon Set with color coding arrows for values in a
cell. I set up a green arrow upward for = and in the "Value" box typed in
=0.90. In the Yellow Sideways Arrow I did and then in the Values box I
have =0.9*0.95. The "Type" is set as Formula.

The problem is that after I save and close, the values for the Green upward
arrow disappear. The values in the Yellow Arrow box stays the same. This
only happens on a couple of cells in a worksheet. Others are holding
properly. I have deleted and redone these twice but the same problem occurs.


The result is that the cell defaults to a green arrow it should be a
downward red arrow because the value is .75. Does anyone know why the values
in the Upward Green Arrows are disappearing for some but not all of these?

Thanks,

Chuck
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
Conditional formatting, Excel 2007 Horatio J. Bilge, Jr. Excel Discussion (Misc queries) 2 June 26th 09 04:16 PM
Conditional Formatting in Excel 2007 Scott Excel Discussion (Misc queries) 1 September 30th 08 11:34 PM
Conditional Formatting in Excel 2007 KiwiGail Excel Discussion (Misc queries) 1 July 29th 08 12:37 PM
Using conditional formatting in Excel 2007 Gunnar Boykin[_2_] New Users to Excel 3 February 6th 08 01:55 PM
Conditional Formatting in Excel 2007 SDR Excel Discussion (Misc queries) 0 November 23rd 07 06:57 AM


All times are GMT +1. The time now is 11:59 PM.

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

About Us

"It's about Microsoft Excel"