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.
|