Hello,
I have a sheet with 6 columns, where I want the row to have strike through if the cell in column F is NOT blank. I have searched and not yet found a way that seems to work for this. If it matters, column F will be holding a date. Any help would be much appreciated.
The TRUE/FALSE formula for row 2 could be:
=LEN($F2)>0
Last edited by JBeaucaire; 09-22-2015 at 03:25 PM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Select the entire range you want this to apply to, then go to Conditional Formatting and select 'New Rule' then 'Use a formula to determine which cells to format'.
Enter either (not both) of these formulae:
=$F1<>""
=LEN($F1)>0
assuming that you want this to start on row one.
(The second formula is Beaucaire's from above, but with the absolute column reference $F instead of just F).
Click 'Format' then click the 'Strikethrough' box (it will start with a green square in it - you need it to have a tick/check in it).
Click OK twice and that should work.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Originally Posted by Aardigspook
Thanks a million! This worked just great. I assume that using the 1st formula is just ensuring the value is NOT equal to NULL basically?
You're welcome and thanks for the rep.
Yes, <> means 'not equal to' so <>"" is 'not equal to null'.
The second formula (Beaucaire's) checks the length of what's in F1, so 'length of F1 greater than 0'.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks