U
UX_108
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) I've managed to use the solution described below, but I haven't been able to figure out how to use this for formating a cell based on a date entered into another cell.
Example: When 1/15/10 is entered into AG4, P4 is highlighted green.
Any help would be appreciated.
-----
"On 6/30/08 7:54 PM, in article (e-mail address removed)9absDaxw,
"[email protected]" wrote:http://www.officeformac.com/macimages/btn_publish.gif
condition 1, select formula is. In the formula section, enter =b20=1, then
set the cell format that you want when b20 is 1."
Example: When 1/15/10 is entered into AG4, P4 is highlighted green.
Any help would be appreciated.
-----
"On 6/30/08 7:54 PM, in article (e-mail address removed)9absDaxw,
"[email protected]" wrote:http://www.officeformac.com/macimages/btn_publish.gif
Yes! Select cell A10. Go to conditional formatting in the format menu. ForVersion: 2008
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: Power PC
>
> hi!
>
> I am makin a decision tree where I would like to by either checking a box or
> write in a value highlight a certain cell. E.g. by writing "1" in cell B20 I
> would like Cell A10 to become green. Is there a way of doing that in Excel
> 2008?
>
> Thanks for your help!
condition 1, select formula is. In the formula section, enter =b20=1, then
set the cell format that you want when b20 is 1."