Formula Color

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Hello all,
could you help me on the following :

If Value in Cell A1 is equal or above Value in A2, I would like cells
A1 and A2 filled in BLUE.

Thanks in advance.

Herve


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27314
View this thread: http://www.excelforum.com/showthread.php?threadid=490843

.

Relevant Pages

  • Re: Referencing a cell for a row
    ... I placed this formula in my cell ... tonydepo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15306 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Autopopulating a cell
    ... an entry into the a1 cell. ... Tralee6 ... Tralee6's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29273 ... Prev by Date: ...
    (microsoft.public.excel)
  • Array Reference
    ... value of a cell? ... accross. ... anar_baku's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18259 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Adding a column
    ... If there is only one number in cell it is counted, if 2, then the one ... in parentheses is the only one of the 2 counted. ... roger_home's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16434 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Help
    ... Use the 'Goal seek' option on the 'Data' menu to find the value of cell ... Deadloss ... Deadloss's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29859 ... Prev by Date: ...
    (microsoft.public.excel.misc)