Conditional formatting question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three cells A1,A2,A3

Together (they are not merge) they make up a descpition field.

When A1 receives 'PROJECT NOT VALID' the shading turns yellow, text turns
red bolded.

I want to shade, color and bold on A2 and A3 when this condition occurs (so
that the field is all yellow when it occurs)

However conditional formatting doesn't allow to reference another cell (or I
cannot find how to do it)

So if I am on A2 and want to say when A1=PROJECT NOT VALID' this would
accomplish what I need.

Any help appreciated.
 
Select A1:A3
Then Format|Condional formatting
Formula is:
=$a$1="project not valid"

And apply the nice format you like.
 
Thanks Dave,also I found I can do a merge cell on this form so that resolved
it as well...
 
The merged cell will resolve this issue and create many more issues with copy,
pasting, sorting, filtering......to name a few.


Gord Dibben MS Excel MVP
 
Back
Top