If B1 is NOT empty highlight A1 (With Attachment)

[Cynops]

for example, If B1 is NOT empty then highlight A1

Then when I add text to A1 get rid of the highlighted cell (this isn't essential - just an added bonus)


Is this possible to do without a VBA?

Thanks!

[cytop]

Deleted - same reply given in another thread for the same issue.

@cynos
If you post duplicate threads for the same issue then please at least have the courtesy to add a links to your threads.