View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] brett.good@jobfindcentre.com.au is offline
external usenet poster
 
Posts: 4
Default Changing a cell colour if target not met.

Hi All,

I am trying to work on a spreadsheet that will allow a cell to change
colour if the right dollar amount is not entered by the current
multipying formula I have in it.

For example.... I currently have a spreadsheet where I calculate
somebodies hours by multiplying there hours cell by using a figure in
another cell..... so basically =(s1*t4), so what I want to do is have
that cell change to Green in $900.00 is met or remain Red if less than
$900 is entered.

Can anybody help me?