LinkBack URL
About LinkBacks
Start with # in COL A, search COL B
if found, take corresponding number in COL C and search COL D
if both found, change background in cond. formatting (FOR COLUMN E....)
Attached sample.
Can't figure out how to code it.
Start with # in COL A, search COL B
if found, take corresponding number in COL C and search COL D
if both found, change background in cond. formatting (FOR COLUMN E....)
Attached sample.
Can't figure out how to code it.
Last edited by x65140; 02-06-2014 at 05:16 AM.
I can't follow your request. What do you mean by 'Start with a # in Col A'? As I look at your example, it looks like you just want to flag when there are numbers in column B and D on the same row.
=and(isnumber(b6),isnumber(d6))
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
Please have a look at the attachment
Martin
Appreciate the help...thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks