View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jose Ruben Gonzalez-Baird Jose Ruben Gonzalez-Baird is offline
external usenet poster
 
Posts: 5
Default Conditionally format cells

I am trying to conditionally format a cell so that, if the value of one cell
is the same as the values in other cells, the formatting of that cell will be
specified a certain way. For instance, I want to check to see if the value
of cell E3 equals value A3. If E3=A3, then I want the formatting of cell E3
to be set such that the shading is a light yellow. Is this possible and if
so is anyone familiar with the syntax?

Thanks for any suggestions. J Ruben.