if D110 then A1 should be red
 

i know it can be done wid conditional formatting but not sure how.

if D110 then A1 should be red
 

Try this:

Select A1

From the Excel main menu:
<format<conditional formatting
Formula is: =$D$110
Click the [Format...] button and set your format.
Click the [OK] buttons

Note: Condition_1 initially displays "Cell Value Is". Click the dropdown
arrow next to that to select "Formula Is".

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Gary" wrote:

i know it can be done wid conditional formatting but not sure how.

if D110 then A1 should be red
 

Thanks ron. can u tell me what if the values are in Time format. now if D1
is greater than 00:10, i want A1 to be red.

thanks in advance

"Ron Coderre" wrote in message
...
Try this:

Select A1

From the Excel main menu:
<format<conditional formatting
Formula is: =$D$110
Click the [Format...] button and set your format.
Click the [OK] buttons

Note: Condition_1 initially displays "Cell Value Is". Click the dropdown
arrow next to that to select "Formula Is".

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Gary" wrote:

i know it can be done wid conditional formatting but not sure how.

if D110 then A1 should be red
 

Ok....Try this as the formula:
=$D$1(--"00:10:00")

Note: the dbl-minus-sign ( -- ) causes Excel to convert the "time text" into
a time value of 10 minutes.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Gary" wrote:

Thanks ron. can u tell me what if the values are in Time format. now if D1
is greater than 00:10, i want A1 to be red.

thanks in advance

"Ron Coderre" wrote in message
...
Try this:

Select A1

From the Excel main menu:
<format<conditional formatting
Formula is: =$D$110
Click the [Format...] button and set your format.
Click the [OK] buttons

Note: Condition_1 initially displays "Cell Value Is". Click the dropdown
arrow next to that to select "Formula Is".

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Gary" wrote:

i know it can be done wid conditional formatting but not sure how.