Cell is colored(red0....based on this how to change other cell val
 

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

Cell is colored(red0....based on this how to change other cell val
 

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