Conditional Formatting based in cell color

E

Emece

Can I use conditional formatting, using as a condition the cell color?

Thanks in advance

Regards,
Emece.-
 
O

Otto Moehrbach

No. But maybe there are other ways of getting what you want. What do you
want to do? HTH Otto
 
E

Emece

Thanks for your reply.

What I want to do is the following:

I have a column with values in red, and values in green (according to a rule
specified using conditional formatting). Depending if the value is red or
green I want to add a percentage.

Hope it is clear.

Thanks again

Regards,
Emece.-
 
D

David Biddulph

Look at the rule used to define the conditional formatting, and include that
rule in the formula for the addition of your percentage.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing row background from external program 0
Conditional Formatting Question 1
Excel 2007 - change size of text as a result of conditional format 4
Address Format changed after Migration 0
Match table shading (color) to Visio color/Transparency 1
vLookup, color as a value 2
Conditional Formatting Excel 2007 2
To find Maximum value using conditional formatting 2

Top