Thread
:
condition format for surrounding cells
View Single Post
#
2
Frank Kabel
Posts: n/a
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 With Quote