Clear column A color if column B has text.

[zone709]

Hi,
Basically i have names that get added in Column A and they are hilighted yellow. I put the correct names in Column B right next to it after that. I need to clear the color yellow in column A when i put the correct names in B and press enter.

Conditional formatting ? Any help thank

 

[Michael M]

You can use CF to do this
Highlight the cell in "A" and then create a new CF rule.
Select the Use a formula line and insert the formula below....assuming the cell is A1

=$B$1<>""

format as required

 

[zone709]

ok thanks I haven't tried it yet ill let know. Thanks for reply

 

[zone709]

ok I just tried this and got it to work, but I cant get it to go in range. I need it to look at name in A:A that are yellow and when added next to in in B:B then clear A:A color. I got this part done but only doing it at a set range A10 to B10 or something like that.

Start:

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

A​

[/th][th]

B​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

402​

[/td][td]Willian[/td][td]William[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

403​

[/td][td=bgcolor:#FFFF00]Espos[/td][td][/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

404​

[/td][td=bgcolor:#FFFF00]Zachar[/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Name Correction[/td][/tr][/table]


Results I need:

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

A​

[/th][th]

B​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

402​

[/td][td]Willian[/td][td]William[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

403​

[/td][td]Espos[/td][td]ESPOSIT[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

404​

[/td][td]Zachar[/td][td]Zachary[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Name Correction[/td][/tr][/table]

I followed your approach and works I just need more range. thanks

 

[Michael M]

when you want to set up an entire range you highlight that range first.....then create the rule !!

 

[zone709]

I think then i'm doing something wrong. I highted the whole range already in Column A then i used your formula in new rule and made that range B:B with $ signs but it did nothing. My situation is sometime i can have 2 yellow cells maybe 4 then the next time 6. i need to just clear the Cells in Col A that are yellow if text is next to it in B

 

[hiker95]

ok I just tried this and got it to work, but I cant get it to go in range. I need it to look at name in A:A that are yellow and when added next to in in B:B then clear A:A color. I got this part done but only doing it at a set range A10 to B10 or something like that.

Start:

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

A​

[/th][th]

B​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

402​

[/td][td]Willian[/td][td]William[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

403​

[/td][td=bgcolor:#FFFF00]Espos[/td][td][/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

404​

[/td][td=bgcolor:#FFFF00]Zachar[/td][td][/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Name Correction[/td][/tr][/table]


Results I need:

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

A​

[/th][th]

B​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

402​

[/td][td]Willian[/td][td]William[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

403​

[/td][td]Espos[/td][td]ESPOSIT[/td][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

404​

[/td][td]Zachar[/td][td]Zachary[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Name Correction[/td][/tr][/table]

I followed your approach and works I just need more range. thanks

zone709,

What product did you use to display the above screenshots?

 

[Michael M]

ooops, sorry....remove the $ signs ...

 

[zone709]

ok ill try this later and let you know. Maybe that's it thanks for replying again.

 

[zone709]

hi its called Forum Tools in top of my excel. Its an Add in and I probably added this awhile ago. Trying to think how I did it, but I got it from this site on how to do it. It copys the range and generates BB Code and then it shows the results as you can see above