Can anyone help me with an IF formula inside conditional formatting?
In my attached worksheet, I have a sheet with a list of names, I would like the data in column B to have a red background only if that name has data next to it in column C.
Any help would be appreciated. Thanks!
named range: Sheet1Data =sheet1B11:C24
Please Login or Register to view this content.
Ben Van Johnson
Use this formula
=C11>0
and your "Apply to: range =$B$11:$B$24
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
What if I had a word instead of a number? So I would want it to recognize any text at all would warrant a red backgroundOriginally Posted by AlKey
It would still work just fine. Just try it
Awesome it does thank you!It would still work just fine. Just try it
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks