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

Formatting row color in table to match first cell in first column 0
if there is a blank ,how to get the blank cell in a range be highlighted 2
How to count cells colored red? 3
how to change color of cell based on contents of cell 3
Apply color of one cell to other 3
how to format cells -fill color 2
Dynamically setting CELL COLORS based on TWO OTHER cell values 3
priority setting 0

Top