Conditional formating based on another cell value

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
Version: 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!
Yes! Select cell A10. Go to conditional formatting in the format menu. For
condition 1, select formula is. In the formula section, enter =b20=1, then
set the cell format that you want when b20 is 1."
 
J

John McGhie

You need to use "Formula is" and put the conditional format into Cell P4.
You insert the conditional format where you want the colour to happen, then
refer to the cell containing the value you want to test.

Since it's a date, and presumably stored as a date, you need to use the DATE
function to convert your comparison value. Like this:

=$AG$4=DATE(2010,1,15)

Cheers

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,
"(e-mail address removed)"
wrote:http://www.officeformac.com/macimages/btn_publish.gif

Yes! Select cell A10. Go to conditional formatting in the format menu. For
condition 1, select formula is. In the formula section, enter =b20=1, then
set the cell format that you want when b20 is 1."

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:[email protected]
 
B

Bob Greenblatt

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,
"(e-mail address removed)"
wrote:http://www.officeformac.com/macimages/btn_publish.gif

Yes! Select cell A10. Go to conditional formatting in the format menu. For
condition 1, select formula is. In the formula section, enter =b20=1, then
set the cell format that you want when b20 is 1."
With Cell P4 selected, enter:=$AG$4=date(2010,1,15) as the conditional
formula.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top