Conditional Formatting

[euphoricdemise]

Hello.

I'm currently working a on sheet for sound changes on a cd in production. Icurrently have all cells set to a default value, in red font, and the current conditional format makes so that if a value is entered other than the default, it changes the font to green, so it's more noticeable to our editors.

I want to add a formula that will keep the above formatting AND include something along the lines of:

If D10="no" then D11="n/a" in grey text, but if D10="yes" then D11="70" in red text.

I've managed to figure out =IF(D10="no", "n/a", "70") but I have to putthat IN the cell, and it overwrites the original conditional formatting.

C D

08 Normalize by: track
09 Smoothing: 3
10 Begin End Fixup Active? yes <-- if this equals no then values below
11 Level %: 70 are changed to "n/a" and greyed out.
12 Backoff: 200 But if cell remains as a yes, then
13 Dialog: 300 values remain in red, unless changed
14 Sentence: 500 manually, then values are in green.
15 Paragraph: 700

Is this able to be done?

 

[Claus Busch]

Hi,

Am Thu, 6 Feb 2014 10:31:51 -0800 (PST) schrieb
(e-mail address removed):

C D

08 Normalize by: track
09 Smoothing: 3
10 Begin End Fixup Active? yes <-- if this equals no then values below
11 Level %: 70 are changed to "n/a" and greyed out.
12 Backoff: 200 But if cell remains as a yes, then
13 Dialog: 300 values remain in red, unless changed
14 Sentence: 500 manually, then values are in green.
15 Paragraph: 700

CF in combination with VBA makes it possible.
Please look here:
https://skydrive.live.com/#cid=9378AAB6121822A3&id=9378AAB6121822A3!326
for the workbook "CF" and download it with right click because macros
are disabled in SkyDrive


Regards
Claus B.