| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
condition format for surrounding cells
Need help, I have column A the have 3 conditional format that is color coded
depending value, I would like to have columns B, C, D,E (which are text) that could changes to the same color as column A when that changes. If anyone could help that would be greatly appriciated. |
|
#2
|
|||
|
|||
|
Hi
try something like the following: - select A1:E1 - in the conditional format dialog enter a formula such as =$A1="condition1" -- Regards Frank Kabel Frankfurt, Germany "little rusty with excel" <little rusty with schrieb im Newsbeitrag ... Need help, I have column A the have 3 conditional format that is color coded depending value, I would like to have columns B, C, D,E (which are text) that could changes to the same color as column A when that changes. If anyone could help that would be greatly appriciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you format a row of cells based upon a value in another ce. | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
| Format cells to display truncated values? | Excel Discussion (Misc queries) | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
Linear Mode
