Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Hi! How can I conditionally format a range of cells so that they change
depending on today's date? For example, I want cells B1 and CI to have a different color today; tomorrow, the color will return to normal for those cells but change for B2 & C2, and son on. Data in columns B & C will have numbers, not dates. Can this be done? Thank you. A B C 1 12/15 1500 1200 2 12/16 3 12/17 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Hi David,
In Excel 2003 you can do this by selecting the range you want to format, click on Tools/Conditional Formatting and for the condition choose "Formula Is" from the drop-down list and enter a formula such as: =$A1=TODAY() for the condition. Then click on the "Format" button to select the format to use for rows with today's date. Click on OK and you should be good to go. HTH, TK "David G." wrote: Hi! How can I conditionally format a range of cells so that they change depending on today's date? For example, I want cells B1 and CI to have a different color today; tomorrow, the color will return to normal for those cells but change for B2 & C2, and son on. Data in columns B & C will have numbers, not dates. Can this be done? Thank you. A B C 1 12/15 1500 1200 2 12/16 3 12/17 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
hi
select b2. in the CF dialog, enter =$A2=Today() copy and Pastespecial fomats down as far as you need. do the same with Column C Regards FSt1 "David G." wrote: Hi! How can I conditionally format a range of cells so that they change depending on today's date? For example, I want cells B1 and CI to have a different color today; tomorrow, the color will return to normal for those cells but change for B2 & C2, and son on. Data in columns B & C will have numbers, not dates. Can this be done? Thank you. A B C 1 12/15 1500 1200 2 12/16 3 12/17 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Thks!
"T Kirtley" wrote: Hi David, In Excel 2003 you can do this by selecting the range you want to format, click on Tools/Conditional Formatting and for the condition choose "Formula Is" from the drop-down list and enter a formula such as: =$A1=TODAY() for the condition. Then click on the "Format" button to select the format to use for rows with today's date. Click on OK and you should be good to go. HTH, TK "David G." wrote: Hi! How can I conditionally format a range of cells so that they change depending on today's date? For example, I want cells B1 and CI to have a different color today; tomorrow, the color will return to normal for those cells but change for B2 & C2, and son on. Data in columns B & C will have numbers, not dates. Can this be done? Thank you. A B C 1 12/15 1500 1200 2 12/16 3 12/17 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |