LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 24
Default Conditional Fromat Question

In C19, I have that cell formatted as a Percentage. I wanted to add
Conditional Formatting as follows:

=$C$19=0 (Format set to the color blue)
=$C$190 (Format set to the color red)
=$C$19<0 (Format set to the color green)

I am attempting to have the color change as the percentage value goes
up/down throughout the month. The percentage changes in C19 based on calc
from other fields. It seems to work except that I start with the 3 rules
above, but end up with dozens of the same rule as C19 changes. Apparently it
appends a rule each time the C19 changes ???
 
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 maybe IF question Zsolt Szabó Excel Discussion (Misc queries) 3 December 10th 06 09:01 PM
Change fromat from number to text trying to delete locking file .ldb Excel Discussion (Misc queries) 3 November 1st 06 09:08 PM
Cell Fromat Protection gmr7 Excel Discussion (Misc queries) 4 January 11th 06 07:25 PM
Time Display in a Stop Watch fromat Gabe Excel Discussion (Misc queries) 7 December 17th 05 08:11 AM
conditional sum question Devlin Excel Worksheet Functions 6 August 17th 05 07:27 AM


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