I'm not sure if this achieved using conditional formatting but it's my only guess on how it might be done.
I want the relationship between my values in column A and column B to give me a result in column C.
I have %'s in column A and B and if my %'s are higher in column B than the corresponding row in column A I want column C to give me a "YES" response and be highlighted. If B<=A I want the corresponding row in column C to say "NO".
How would I achieve this? Thanks.
Bookmarks