Integers and adjacent cells

[andrewb63]

Hi all

In column E I have document version numbers and if the document number contains a zero (1.0, 2.0 etc) I want the cells in same row in Cols H and I to highlight to identify that I need to add further text.
If the cell is a none 'whole' number (1.2, 2.3 etc.) no action is required.

I'm sure it's a simple one but I can't work it out!!

Thanks in advance.

 

[Fluff]

How about

+Fluff 1.xlsm
	E	F	G	H	I
6	1.0
7	1.1
8	2.0
9	2.3
10	3.0
Main

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
H6:I10	Expression	=MOD($E6,1)=0	text	NO

 

[andrewb63]

Thanks Fluff, works perfectly and saved me a lot (more) time.
Cheers

 

[Fluff]

You're welcome & thanks for the feedback.