Conditional Formula - Strikethrough

V

VBA Noob

Active Member

Joined

Apr 27, 2006

Messages

353

• Aug 7, 2008

• #2

Select Col B and then use

=$D1<>""

Click to expand...

VBA Noob

 

Upvote 0

G

Gettingbetter

Well-known Member

Joined

Oct 12, 2004

Messages

602

• Aug 7, 2008

• #3

in your conditional format for B7

Choose 'Formula Is' and then type =IF(D7<>"",TRUE,FALSE)

Add the format of a strikethrough

and your done.

This can be copied all the way down column B if you need

Cheers
GB

 

Upvote 0

erik.van.geit

MrExcel MVP

Joined

Feb 1, 2003

Messages

17,832

• Aug 7, 2008

• #4

Hi,

The concept of conditional format is to test a formula to be true or false.
=$D1="" is enough
no need to use a "normal" formula
=IF(...,True,False)

When trying to find a formula for conditional format, you can fill in the raw formula in any cell to test. (displayed result will be TRUE or FALSE)

kind regards,
Erik

 

Upvote 0

funkcreep

New Member

Joined

Jul 14, 2005

Messages

48

• Aug 7, 2008

• #5

Thanks...that just what I needed.

Louis

 

Upvote 0