ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Formatting based in cell color (https://www.excelbanter.com/excel-discussion-misc-queries/216760-conditional-formatting-based-cell-color.html)

Emece

Conditional Formatting based in cell color
 
Can I use conditional formatting, using as a condition the cell color?

Thanks in advance

Regards,
Emece.-

Otto Moehrbach[_2_]

Conditional Formatting based in cell color
 
No. But maybe there are other ways of getting what you want. What do you
want to do? HTH Otto
"Emece" wrote in message
...
Can I use conditional formatting, using as a condition the cell color?

Thanks in advance

Regards,
Emece.-




Emece

Conditional Formatting based in cell color
 
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.-

"Otto Moehrbach" wrote:

No. But maybe there are other ways of getting what you want. What do you
want to do? HTH Otto
"Emece" wrote in message
...
Can I use conditional formatting, using as a condition the cell color?

Thanks in advance

Regards,
Emece.-





David Biddulph[_2_]

Conditional Formatting based in cell color
 
Look at the rule used to define the conditional formatting, and include that
rule in the formula for the addition of your percentage.
--
David Biddulph

"Emece" wrote in message
...
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.-

"Otto Moehrbach" wrote:

No. But maybe there are other ways of getting what you want. What do
you
want to do? HTH Otto
"Emece" wrote in message
...
Can I use conditional formatting, using as a condition the cell color?

Thanks in advance

Regards,
Emece.-








All times are GMT +1. The time now is 04:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com