Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
hightlight cells
i need to hightlight a cell when i have one birthday in my list
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
hightlight cells
Suppose you have the list of birthdays as a named range ...and with dates in
Column D. Select Column D..and apply the conditional form 1. Select the dates are in Range (say D1:D10). Please note that the cell reference D1 mentioned in the formula is the active cell in the selection. Active cell will have a white background even after selection 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula 'if you have a named range 'birthdays' =COUNTIF(birthdays,D1) OR 'if the birthdays are mentioned in the same sheet say J1:J10 then try =COUNTIF($J$1:$J$10,D1) 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK PS: If you are using XL2007 Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a formula to determine which cells to format. Enter the formula in the box below. "sookie" wrote: i need to hightlight a cell when i have one birthday in my list |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hightlight cells that contain special characters | Excel Worksheet Functions | |||
Hightlight Cell | Setting up and Configuration of Excel | |||
Hightlight date range | New Users to Excel | |||
condtional format - hightlight max results | Excel Discussion (Misc queries) | |||
HIGHTLIGHT ROW BASED ON TEXT IN ANOTHER CELL | Excel Worksheet Functions |