formula for if Cell c1 is yellow shaded cell d1 should be yellow

H

Hardeep

Do we have formulas for Color shading also. like if particular cell is yellow
than entire row should be yellow or like wise
 
D

Dave Peterson

Maybe.

You can use the value in a cell to color a cell (or a row of cells).

Take a look at Format|conditional formatting.

But there's nothing built into excel that will use the color of a cell (font or
fill).

Chip Pearson has some userdefined functions that can return the colorindex (and
you could use that in your conditional formatting):

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