Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply conditional formatting on group of cells by using dat
Hi,
I have a sheet for tracking vacation plan. In this sheet I want to make a conditional formatting. The sheet contains three columns, the first one is employee name, and the second one is last working day, the third one is return to work. I want to apply specific conditional formatting on the three columns by special conditional as follows: If the last working day date is over due itself, the all columns to be filled with color automatically. Your help is highly appreciated |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply conditional formatting on group of cells by using dat
Hi Jon
Mark the range of cells you want to apply the CF to. FormatConditional Formattinguse dropdown for Formula is =AND($B1<"",TODAY()-$B10) Choose Format you require. -- Regards Roger Govier "Jon" wrote in message ... Hi, I have a sheet for tracking vacation plan. In this sheet I want to make a conditional formatting. The sheet contains three columns, the first one is employee name, and the second one is last working day, the third one is return to work. I want to apply specific conditional formatting on the three columns by special conditional as follows: If the last working day date is over due itself, the all columns to be filled with color automatically. Your help is highly appreciated |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply conditional formatting on group of cells by using
thanks a lost , it works
but for more clarification the B1 is the cell for €śLast working Day Date€ť "Roger Govier" wrote: Hi Jon Mark the range of cells you want to apply the CF to. FormatConditional Formattinguse dropdown for Formula is =AND($B1<"",TODAY()-$B10) Choose Format you require. -- Regards Roger Govier "Jon" wrote in message ... Hi, I have a sheet for tracking vacation plan. In this sheet I want to make a conditional formatting. The sheet contains three columns, the first one is employee name, and the second one is last working day, the third one is return to work. I want to apply specific conditional formatting on the three columns by special conditional as follows: If the last working day date is over due itself, the all columns to be filled with color automatically. Your help is highly appreciated |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply conditional formatting on group of cells by using
Hi Jon
Yes, from your description, column B contains the last working day. The column is Fixed with $B but the row is relative and will change from 1 to 2 etc. as you go down the page. So if you were looking at row 9, the formula would have become =AND($B9<"",TODAY()-$B90) We need the test to see whether column B is empty, otherwise all blank rows would be formatted with your chosen format as well. -- Regards Roger Govier "Jon" wrote in message ... thanks a lost , it works but for more clarification the B1 is the cell for "Last working Day Date" "Roger Govier" wrote: Hi Jon Mark the range of cells you want to apply the CF to. FormatConditional Formattinguse dropdown for Formula is =AND($B1<"",TODAY()-$B10) Choose Format you require. -- Regards Roger Govier "Jon" wrote in message ... Hi, I have a sheet for tracking vacation plan. In this sheet I want to make a conditional formatting. The sheet contains three columns, the first one is employee name, and the second one is last working day, the third one is return to work. I want to apply specific conditional formatting on the three columns by special conditional as follows: If the last working day date is over due itself, the all columns to be filled with color automatically. Your help is highly appreciated |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply conditional formatting on group of cells by using
what about apply the CF 1 day before the specific date
"Roger Govier" wrote: Hi Jon Yes, from your description, column B contains the last working day. The column is Fixed with $B but the row is relative and will change from 1 to 2 etc. as you go down the page. So if you were looking at row 9, the formula would have become =AND($B9<"",TODAY()-$B90) We need the test to see whether column B is empty, otherwise all blank rows would be formatted with your chosen format as well. -- Regards Roger Govier "Jon" wrote in message ... thanks a lost , it works but for more clarification the B1 is the cell for "Last working Day Date" "Roger Govier" wrote: Hi Jon Mark the range of cells you want to apply the CF to. FormatConditional Formattinguse dropdown for Formula is =AND($B1<"",TODAY()-$B10) Choose Format you require. -- Regards Roger Govier "Jon" wrote in message ... Hi, I have a sheet for tracking vacation plan. In this sheet I want to make a conditional formatting. The sheet contains three columns, the first one is employee name, and the second one is last working day, the third one is return to work. I want to apply specific conditional formatting on the three columns by special conditional as follows: If the last working day date is over due itself, the all columns to be filled with color automatically. Your help is highly appreciated |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply conditional formatting on group of cells by using
what about apply the CF 1 day before the specific date
"Roger Govier" wrote: Hi Jon Yes, from your description, column B contains the last working day. The column is Fixed with $B but the row is relative and will change from 1 to 2 etc. as you go down the page. So if you were looking at row 9, the formula would have become =AND($B9<"",TODAY()-$B90) We need the test to see whether column B is empty, otherwise all blank rows would be formatted with your chosen format as well. -- Regards Roger Govier "Jon" wrote in message ... thanks a lost , it works but for more clarification the B1 is the cell for "Last working Day Date" "Roger Govier" wrote: Hi Jon Mark the range of cells you want to apply the CF to. FormatConditional Formattinguse dropdown for Formula is =AND($B1<"",TODAY()-$B10) Choose Format you require. -- Regards Roger Govier "Jon" wrote in message ... Hi, I have a sheet for tracking vacation plan. In this sheet I want to make a conditional formatting. The sheet contains three columns, the first one is employee name, and the second one is last working day, the third one is return to work. I want to apply specific conditional formatting on the three columns by special conditional as follows: If the last working day date is over due itself, the all columns to be filled with color automatically. Your help is highly appreciated |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply conditional formatting on group of cells by using
Hi Jon
=AND($B9<"",TODAY()-$B9+10) -- Regards Roger Govier "Jon" wrote in message ... what about apply the CF 1 day before the specific date "Roger Govier" wrote: Hi Jon Yes, from your description, column B contains the last working day. The column is Fixed with $B but the row is relative and will change from 1 to 2 etc. as you go down the page. So if you were looking at row 9, the formula would have become =AND($B9<"",TODAY()-$B90) We need the test to see whether column B is empty, otherwise all blank rows would be formatted with your chosen format as well. -- Regards Roger Govier "Jon" wrote in message ... thanks a lost , it works but for more clarification the B1 is the cell for "Last working Day Date" "Roger Govier" wrote: Hi Jon Mark the range of cells you want to apply the CF to. FormatConditional Formattinguse dropdown for Formula is =AND($B1<"",TODAY()-$B10) Choose Format you require. -- Regards Roger Govier "Jon" wrote in message ... Hi, I have a sheet for tracking vacation plan. In this sheet I want to make a conditional formatting. The sheet contains three columns, the first one is employee name, and the second one is last working day, the third one is return to work. I want to apply specific conditional formatting on the three columns by special conditional as follows: If the last working day date is over due itself, the all columns to be filled with color automatically. Your help is highly appreciated |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to apply conditional formatting on group of cells by using
hi,
it does not work "Roger Govier" wrote: Hi Jon =AND($B9<"",TODAY()-$B9+10) -- Regards Roger Govier "Jon" wrote in message ... what about apply the CF 1 day before the specific date "Roger Govier" wrote: Hi Jon Yes, from your description, column B contains the last working day. The column is Fixed with $B but the row is relative and will change from 1 to 2 etc. as you go down the page. So if you were looking at row 9, the formula would have become =AND($B9<"",TODAY()-$B90) We need the test to see whether column B is empty, otherwise all blank rows would be formatted with your chosen format as well. -- Regards Roger Govier "Jon" wrote in message ... thanks a lost , it works but for more clarification the B1 is the cell for "Last working Day Date" "Roger Govier" wrote: Hi Jon Mark the range of cells you want to apply the CF to. FormatConditional Formattinguse dropdown for Formula is =AND($B1<"",TODAY()-$B10) Choose Format you require. -- Regards Roger Govier "Jon" wrote in message ... Hi, I have a sheet for tracking vacation plan. In this sheet I want to make a conditional formatting. The sheet contains three columns, the first one is employee name, and the second one is last working day, the third one is return to work. I want to apply specific conditional formatting on the three columns by special conditional as follows: If the last working day date is over due itself, the all columns to be filled with color automatically. Your help is highly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
APPLY CONDITIONAL FORMATTING TO A ROW IN EXCEL | Excel Discussion (Misc queries) | |||
How do I apply conditional formatting to even or odd numbers? | Excel Discussion (Misc queries) | |||
I need conditional formatting to apply to maximum % | Excel Worksheet Functions | |||
How do I apply conditional formatting? | Excel Worksheet Functions | |||
Can I Apply Conditional Formatting to a Chart? | Charts and Charting in Excel |