Conditional formatting anomaly?

[Bebbspoke]

Hi Folks -

I use Windows 10 & subscribe to Office 365.
I am using 64-bit Excel as my data workbook is > 0.9Gb

I have Col D with the formula =IF(OR(B2="W",B2="L",B2="ne"),NETWORKDAYS.INTL($A2,C2,"1111101"),"")

This procures the number of weekends a process (as result = Col B) took to complete,
the start time being Col A and finish time is Col C. Nothing wrong with that.... it works correctly.

The appropriate cells in Col D are blank ("") for no process or contain a numeral.

I wish to highlight each Col D cell which contains (any) number - however - when I apply the Conditional Formatting > Highlight Cell Rules > Greater than > 0.5
then ALL cells including the blanks are highlighted??? - which seems most irrational and does NOT produce the given function!

Any suggestions, please?

 

[etaf]

try setting up a rule and usingthe following formula

=AND(D2 < > "", D2 > 0.5 )
Assumes you select a range D2:D???

if you just want to use column D
D:D
then the formulas needs to change to use row1
=AND(D1 < > "", D1 > 0.5 )

 

[friel300]

if you are just looking to hilight the cells then you can use a conditional formatting formula

=D1<>""

 

[MARK858]

if you are just looking to hilight the cells then you can use a conditional formatting formula

=D1<>""

I think that you are missing the >0.5 requirement
Although the original question is unclear as the OP does also state any number

 

[Bebbspoke]

Hi folks,

Thank you for your suggestions - the requirement is; -

Neither Blank cells (i.e. "") nor (numerical) zero are NOT to be highlighted

Cells with numeral > zero ALL to be highlighted.

Thank you "etaf" - your solution works.

 

[etaf]

based on your statement
anything between 0 and 0.5 should also be highlighted

so this should work

=AND(D1 < > "", D1 > 0 )

 

[Bebbspoke]

based on your statement
anything between 0 and 0.5 should also be highlighted

so this should work

=AND(D1 < > "", D1 > 0 )

Hi Etaf - no problems - with 0><1 as numerals can only be integers in the stated example.

Thanks.