| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Color
You can use Condition Formatting (CF) to do this. Select cells A1
and A2. Go to the Format menu, and choose CF. In that dialog, change "Cell Value Is" to "Formula Is" and enter =$A$1<=$A$2 in the formula box and click Format to choose your formatting. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "herve" wrote in message ... 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...o&userid=27314 View this thread: http://www.excelforum.com/showthread...hreadid=490843 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Portion of concatenate formula to have different color and font fo | Excel Worksheet Functions | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
| How do I create formula to change cell color | Excel Worksheet Functions | |||
Threaded Mode
