View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] ato_zee@hotmail.com is offline
external usenet poster
 
Posts: 19
Default Validate cell equality by conditional fill problem


On 1-Dec-2007, Gord Dibben <gorddibbATshawDOTca wrote:

In that case maybe =ROUND($H1,0)<$G1 depending upon DP in column G


Many thanks, it needed the ROUND to work, even though all the
values were entered in integers.