if D1>10 then A1 should be red

[Gary]

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

 

[Ron Coderre]

Try this:

Select A1

From the Excel main menu:
<format><conditional formatting>
Formula is: =$D$1>10
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]

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

Try this:

Select A1

From the Excel main menu:
<format><conditional formatting>
Formula is: =$D$1>10
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

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

 

[Ron Coderre]

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

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

Try this:

Select A1

From the Excel main menu:
<format><conditional formatting>
Formula is: =$D$1>10
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

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