Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting when entering a date
I have reviewed a number of posts on conditional formatting, but have not
found my answer yet. Here's my problem: I am attempting to shade a row after a date is entered in a specific cell. Essentially, I want the row shaded whenever anything is entered in the specific cell. I appreciate any help. Thank you Tony |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting when entering a date
One more on this topic. How do I take a number like (97.5) and convert this
to time (97:30) Thanks "tongon" wrote: I have reviewed a number of posts on conditional formatting, but have not found my answer yet. Here's my problem: I am attempting to shade a row after a date is entered in a specific cell. Essentially, I want the row shaded whenever anything is entered in the specific cell. I appreciate any help. Thank you Tony |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting when entering a date
Sorry replied to the wrong post
"JR" wrote: One more on this topic. How do I take a number like (97.5) and convert this to time (97:30) Thanks "tongon" wrote: I have reviewed a number of posts on conditional formatting, but have not found my answer yet. Here's my problem: I am attempting to shade a row after a date is entered in a specific cell. Essentially, I want the row shaded whenever anything is entered in the specific cell. I appreciate any help. Thank you Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting, date. | Excel Worksheet Functions | |||
Conditional formatting of date | Excel Discussion (Misc queries) | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
conditional formatting conflict? | Excel Worksheet Functions |