Previous Topic Next Topic

Conditional formatting

Closed
Zach - Apr 14, 2009 at 03:07 PM
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 - Apr 15, 2009 at 01:53 AM
Hello,

I have a list of addresses, and I have incorrect addresses (in column G) marked in red. I want the name (in column B) associated with that address which appears in the same row to turn red as well as a way to know the name is associated with an incorrect address. How do I use conditional formatting to make the name appear red? I need something like "If G3 is red, make B3 red." Is that possible?

Thanks,
Zach

1 response

Answer 1 / 1
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 165
Apr 15, 2009 at 01:53 AM
Its simple but will you clarify that you have incorrect data in column G marked as Red .... did you extract data from some other columns ????

Then you are talking about Names in Column B please give example like this

G
incorrect address1
incorrect address2
incorrect address3

ColunB
is it contain Names or Addresses ?????
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses