Hi
I am stuck. I need a conditioning format formula please. If cell A2 is less than 50% of cell A1, then highlight red. For the life of me, it seems easy, but I cant figure it out.
Any help would be appreciated.
Thanks
Hi
I am stuck. I need a conditioning format formula please. If cell A2 is less than 50% of cell A1, then highlight red. For the life of me, it seems easy, but I cant figure it out.
Any help would be appreciated.
Thanks
=a2<a1*0.5
Thank you so much, works like a charm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks