Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula for if Cell c1 is yellow shaded cell d1 should be yellow
Do we have formulas for Color shading also. like if particular cell is yellow
than entire row should be yellow or like wise |
#2
|
|||
|
|||
formula for if Cell c1 is yellow shaded cell d1 should be yellow
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 Hardeep wrote: Do we have formulas for Color shading also. like if particular cell is yellow than entire row should be yellow or like wise -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
looking for a formula | Excel Worksheet Functions |