Re: sense conditional formating

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank You
I receive the spread*** with the colors set based on human investigation
( I do not know the procedures they use to set some values to red or green).
I have been asked to sum the red values, the green values and the normal
display values.
Where do I find documentation regarding UDF?
Thanks,
Greg
"Peo Sjoblom" <terre08@xxxxxxxx> wrote in message
news:OvbaZqVcHHA.4460@xxxxxxxxxxxxxxxxxxxxxxx
There is nothing like that built in, why are the colours there in the
first
place?
Can you used that as a condition? For example if you colour cells that are
greater than 10 green, then you could use >10 as a condition
Otherwise you need to use a UDF (write code to build your own function)

http://www.cpearson.com/excel/colors.htm


Regards,

Peo Sjoblom




"Greg" <gfjesky@xxxxxxxxxxxxx> wrote in message
news:WWwOh.10249$5i7.7042@xxxxxxxxxxxxxxxxxxxxxxxxx
To All,

A basic question regarding conditional Formatting.

I can not determine how to perform an IF function based on the color of
a
cell. For example, I would like to add a column but exclude any
numbers(values) in that column designated with a color red or green.

Can this be done? How can it be done. I have not found how to do it in
HELP.

Thank You,
Greg







.

Quantcast