I have a column of data in Column J and K. What I want to do is if Column J has any data in it, highlight the corresponding cell in Column K... can't seem to figure the right formula in the Cond Form. section.
I have a column of data in Column J and K. What I want to do is if Column J has any data in it, highlight the corresponding cell in Column K... can't seem to figure the right formula in the Cond Form. section.
The Formula could depend on what sort of data you have (e.g. numbers, text, etc)
Try this. Select column K and Conditional Formatting >Use Formula
=LEN(J1)>0
Select your formatting.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Dates starting in 1900 are numbers to Excel. In the attached sheet, I just used =$B1>0 for the formula in conditional formatting. As long as there are no numbers in the rest of the column this should work.
Edit: nm, totally read that as date and not data.
Last edited by OU405; 04-23-2010 at 04:44 PM.
let me try.. sorry I should have noted it's letters, either AF, AD, HF,or HD.. I just figured it would be easier to say if it's blank or contains data rather than look for those 4 specific sets...
it turned the whole column green
Can you attach your workbook (with the faulty conditional formatting)?
You could just make four rules looking for each value like below. I'm sure there's a better way, but this should work.
=$J1="AF"
=$J1="AD"
=$J1="HF"
=$J1="HD"
oh I figured it out.. user error.. thanks.. it can be closed!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks