View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Conditionally formatting a cell based on other cell values

What version of Excel are you using?

--
Biff
Microsoft Excel MVP


"ian" wrote in message
...
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!