if the color was "manually" set, you can't

but if the color is based on Confitional Formatting, then you can use that
condition to change the value of another cell.

"abhilash01" wrote:

Hi Folks

i am a rookie facing a problem...

A cell is already colored say red, based on a particular color(red,
orange...etc.)....how can i change the value of another cell

Kindly help me out

tia