Changing a cell colour if target not met.
On Apr 27, 12:42*pm, wrote:
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?
Hello?
|