| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting help
I have set the following conditions for my worksheet:
=(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DAY(E7))) will shade red =(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DAY(E7))) will shade yellow These conditions are set to each cell in the worksheet. The problem I having is all the blank, or unfilled, blocks are now shaded red. I need them unshaded if they are empty. What am I doing wrong or missing? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting help
=AND(E7<"",(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DA Y(E7))))
=AND(E7<"",(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DA Y(E7)))) -- __________________________________ HTH Bob "Dolphin" wrote in message ... I have set the following conditions for my worksheet: =(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DAY(E7))) will shade red =(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DAY(E7))) will shade yellow These conditions are set to each cell in the worksheet. The problem I having is all the blank, or unfilled, blocks are now shaded red. I need them unshaded if they are empty. What am I doing wrong or missing? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting help
Thanks, Bob. That worked great!
"Bob Phillips" wrote: =AND(E7<"",(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DA Y(E7)))) =AND(E7<"",(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DA Y(E7)))) -- __________________________________ HTH Bob "Dolphin" wrote in message ... I have set the following conditions for my worksheet: =(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DAY(E7))) will shade red =(TODAY()=DATE(YEAR(E7)+1,MONTH(E7),DAY(E7))) will shade yellow These conditions are set to each cell in the worksheet. The problem I having is all the blank, or unfilled, blocks are now shaded red. I need them unshaded if they are empty. What am I doing wrong or missing? |
| 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 | |||
Linear Mode
