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

A

abhilash01

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
 
D

dlw

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.
 

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

how to change color of cell based on contents of cell 2
Dynamically setting CELL COLORS based on TWO OTHER cell values 4
Apply color of one cell to other 2
Changing a color in a cell based on the text in another cell 3
how to autoformat cell based on certain conditions 1
Transfer Cell Formatting for linked cells 2
Change cell background color based on content that results from li 4
conditional formatting one cell based on content of another cell 3

Top