Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I highlight a cell if it meets year and month criteria
This is the formula that I have in the column:
=IF(K104=0,"",(DATE(YEAR(K104),MONTH(K104)+24,DAY( K104)))) If the month and year is reached I want the cell highlighted in red, if exceeded I want the cell in yellow. How do I do this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I highlight a cell if it meets year and month criteria
Look at format_conditional formating Choose 2 conditions and the colours you require if they are met Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=541048 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how can I highlight a cell if it meets year and month criteria
You would do this using conditional formatting. Let's say you want to have
the cell highlighted if the date is <= today. Select the cells Format - Conditional formatting Formula is: (select the first cell) and then enter <= today() You should see something like =$A$1<=today() You will probably want to remove the $ from the formula if it applies to multiple cells. HTH. Barb Reinhardt "Clyde" wrote: This is the formula that I have in the column: =IF(K104=0,"",(DATE(YEAR(K104),MONTH(K104)+24,DAY( K104)))) If the month and year is reached I want the cell highlighted in red, if exceeded I want the cell in yellow. How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I keep a value visible, once criteria for that value chang | Excel Discussion (Misc queries) | |||
Counting distinct entries based on meeting month & year criteria | Excel Worksheet Functions | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
HELP - need to returns the current number of past month this year and ... | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions |