Hi there,
I have a list of keywords in one column and their changes in rankings in another - positive value for increase in rank (1) and negative value for loss in rank (-1).
I would like a formula which will highlight the keyword in either green for an increase or red for a loss.
There is most likely a simple solution but I'm relatively new to formula building within CF.
Any help is appreciated!
Thanks,
Andrew
So, are you saying, if there is a positive value in column C, highlight the keyword in Column B in Green? And, if there is a negative value in column C, highlight the keyword in column C in Red? What if the value is zero?
In simple terms, select B2:Bn where n is the last row of data (or some arbitrary maximum). Then, for Green, use the formula =AND(C2<>"", C2>0). For Red, use =AND(C2<>"", C2<0)
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi there,
If they are zero then they can remain as normal.
I applied your formula and it worked great! Thank you very much for your help!
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks