Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Conditional Formating Issue

Okay, I have a problem with a set of conditional formatting. I guess the
easy way to explain this is to give the values of cells in question, and the
setup of the conditional formatting, so here goes.

Cell R2 Value: 500
Cell S2 Value: 1000
Cell T2 Value: 3750
Cell U2 Value: 5250
Cell V2 Value: Ever changing

All Conditional Format are set for "Format Values where this formula is true:"

Cell R2 Conditional Format: =V20 (Red), =V2R2*0.25-1 (Orange),
=V2R2*0.50-1 (Yellow), =V2R2*0.75-1 (Light Green), =V2R2-1 (Green)

Cell S2 Conditional Format: =V2-R20 (Red), =V2-R2S2*0.25-1 (Orange),
=V2-R2S2*0.50-1 (Yellow), =V2-R2S2*0.75-1 (Light Green), =V2-R2S2-1 (Green)

Cell T2 Conditional Format: =V2-R2-S20 (Red), =V2-R2-S2T2*0.25-1 (Orange),
=V2-R2-S2T2*0.50-1 (Yellow), =V2-R2-S2T2*0.75-1 (Light Green),
=V2-R2-S2T2-1 (Green)

Cell U2 Conditional Format: =V20 (Red), =V2U2*0.25-1 (Orange),
=V2U2*0.50-1 (Yellow), =V2U2*0.75-1 (Light Green), =V2U2-1 (Green)

Now as V2 increases, each cell will change color 5 times. The same formating
is copy and pasted to the cells right below them (R3:R43, S3:S43, T3:T43,
U3:U43). Now, when V2 reaches the point to where S2 will change from Yellow
to Light Green (1250), S3 thru S43 also turns light green. V2 is the only
cell that causes this issue. All the other V cells when they reach the point
where the the Cell is Column S changes from Yellow to Green, only that cell
changes, not the ones below it.

Why is this? If you need my actual workbook information, please feel free to
email me at (remove the asterisk).
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Conditional Formating Issue

Okay, i don't know what I did, but I got i worked out. I went through and
saved the file as another name, deleted the conditional formats, and
re-entered them. I used the same conditional formats with the same formula,
and now the issue is no longer working. Some how the one cell was linked or
referenced in the other file.

"Thomas Dieter" wrote:

Okay, I have a problem with a set of conditional formatting. I guess the
easy way to explain this is to give the values of cells in question, and the
setup of the conditional formatting, so here goes.

Cell R2 Value: 500
Cell S2 Value: 1000
Cell T2 Value: 3750
Cell U2 Value: 5250
Cell V2 Value: Ever changing

All Conditional Format are set for "Format Values where this formula is true:"

Cell R2 Conditional Format: =V20 (Red), =V2R2*0.25-1 (Orange),
=V2R2*0.50-1 (Yellow), =V2R2*0.75-1 (Light Green), =V2R2-1 (Green)

Cell S2 Conditional Format: =V2-R20 (Red), =V2-R2S2*0.25-1 (Orange),
=V2-R2S2*0.50-1 (Yellow), =V2-R2S2*0.75-1 (Light Green), =V2-R2S2-1 (Green)

Cell T2 Conditional Format: =V2-R2-S20 (Red), =V2-R2-S2T2*0.25-1 (Orange),
=V2-R2-S2T2*0.50-1 (Yellow), =V2-R2-S2T2*0.75-1 (Light Green),
=V2-R2-S2T2-1 (Green)

Cell U2 Conditional Format: =V20 (Red), =V2U2*0.25-1 (Orange),
=V2U2*0.50-1 (Yellow), =V2U2*0.75-1 (Light Green), =V2U2-1 (Green)

Now as V2 increases, each cell will change color 5 times. The same formating
is copy and pasted to the cells right below them (R3:R43, S3:S43, T3:T43,
U3:U43). Now, when V2 reaches the point to where S2 will change from Yellow
to Light Green (1250), S3 thru S43 also turns light green. V2 is the only
cell that causes this issue. All the other V cells when they reach the point
where the the Cell is Column S changes from Yellow to Green, only that cell
changes, not the ones below it.

Why is this? If you need my actual workbook information, please feel free to
email me at (remove the asterisk).

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 Formating Issue adam Excel Programming 3 May 26th 08 03:58 PM
Formating issue Ramone Excel Discussion (Misc queries) 2 February 18th 07 02:41 AM
Conditional Formating issue..... WalterT. Excel Worksheet Functions 3 December 9th 05 01:31 AM
Install dates formating using conditional formating? Jerry Eggleston Excel Discussion (Misc queries) 2 November 9th 05 06:49 PM
Conditional Formating issue jurgenC![_2_] Excel Programming 2 February 3rd 04 12:22 AM


All times are GMT +1. The time now is 01: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"