Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
if D110 then A1 should be red
i know it can be done wid conditional formatting but not sure how.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|