View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Russell Dawson[_2_] Russell Dawson[_2_] is offline
external usenet poster
 
Posts: 181
Default Conditionally formatting a cell based on other cell values

Please give a full explanation
--
Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"ian" wrote:

I am trying to format a cell based upon the relationship of another cell to a
reference value. For instance if the reference is 5 and the other cell is 4
I want to format the original cell green, if it is the same blue and if it is
less than the reference red.

Can someone help please!