Highlighting a cell above a cell with bold text

[jo206]

hi all

I am looking for a way (CF or VBA) to achieve below, can anyone please help?

all my data are under Col A. and want to achieve lets say if A2038 is in Bold, then A2037 gets highlighted.

thanks in advance!
J

 

[awoohaw]

How do you make the bold cells bold? Is there a rule that you have for that?

 

[jo206]

How do you make the bold cells bold? Is there a rule that you have for that?

yea, I already have another CF that makes certain cells bold (based on cells from another sheet)

and I want cells above any bold cells to be highlighted in red. so it's a two step process

Ideally I want a CF or VBA to highlight one row above any cell that has same data in another sheet but I wasn't able to figure this out so asking this instead (for example if A2038 contains Orange Juice and also found in Col A in another sheet then A2037 gets highlighted)

 

[jo206]

figured out, thanks!