Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MULTIPLE CONDITIONAL FORMATS
Column D is formated as follows ="TODAY()-90" so that if it is over 90 days
past due the font will turn red... but I am trying to format it so that if I have text entered into column F it stays black as the format doesn't apply... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MULTIPLE CONDITIONAL FORMATS
In Excel 2003 you can have upto three conditions and the first one which is
found to be true is applied to the cell. "Pattee" wrote: Column D is formated as follows ="TODAY()-90" so that if it is over 90 days past due the font will turn red... but I am trying to format it so that if I have text entered into column F it stays black as the format doesn't apply... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MULTIPLE CONDITIONAL FORMATS
I know but I can not get it to work... It doesn't recognize that I have
anything in G... Maybe I am not setting it up right... so I would have the one (column D) ="TODAY()-90" be the second condition but how would I set up the second one that states column D doesn't turn red text is entered in column F? "Sheeloo" wrote: In Excel 2003 you can have upto three conditions and the first one which is found to be true is applied to the cell. "Pattee" wrote: Column D is formated as follows ="TODAY()-90" so that if it is over 90 days past due the font will turn red... but I am trying to format it so that if I have text entered into column F it stays black as the format doesn't apply... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MULTIPLE CONDITIONAL FORMATS
Remove the quote marks from the formula.
You are currently looking for the text string "TODAY()-90" -- David Biddulph "Pattee" wrote in message ... I know but I can not get it to work... It doesn't recognize that I have anything in G... Maybe I am not setting it up right... so I would have the one (column D) ="TODAY()-90" be the second condition but how would I set up the second one that states column D doesn't turn red text is entered in column F? "Sheeloo" wrote: In Excel 2003 you can have upto three conditions and the first one which is found to be true is applied to the cell. "Pattee" wrote: Column D is formated as follows ="TODAY()-90" so that if it is over 90 days past due the font will turn red... but I am trying to format it so that if I have text entered into column F it stays black as the format doesn't apply... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MULTIPLE CONDITIONAL FORMATS
Select Col D (if you want to highlight Col D based on Col F)
Choose Formula is Enter the formula as =F1<"" if D1 is the first cell you have selected. This will be true whenever F has a value in corresponding row. Have this as the first condition. If you want to highlight the whole row, then select multiple columns and enter the condition as =$F1<"" "Pattee" wrote: I know but I can not get it to work... It doesn't recognize that I have anything in G... Maybe I am not setting it up right... so I would have the one (column D) ="TODAY()-90" be the second condition but how would I set up the second one that states column D doesn't turn red text is entered in column F? "Sheeloo" wrote: In Excel 2003 you can have upto three conditions and the first one which is found to be true is applied to the cell. "Pattee" wrote: Column D is formated as follows ="TODAY()-90" so that if it is over 90 days past due the font will turn red... but I am trying to format it so that if I have text entered into column F it stays black as the format doesn't apply... |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MULTIPLE CONDITIONAL FORMATS
Why not combine the condition as:
AND(D1<TODAY()-90,F1<"") and copy down "Sheeloo" wrote: Select Col D (if you want to highlight Col D based on Col F) Choose Formula is Enter the formula as =F1<"" if D1 is the first cell you have selected. This will be true whenever F has a value in corresponding row. Have this as the first condition. If you want to highlight the whole row, then select multiple columns and enter the condition as =$F1<"" "Pattee" wrote: I know but I can not get it to work... It doesn't recognize that I have anything in G... Maybe I am not setting it up right... so I would have the one (column D) ="TODAY()-90" be the second condition but how would I set up the second one that states column D doesn't turn red text is entered in column F? "Sheeloo" wrote: In Excel 2003 you can have upto three conditions and the first one which is found to be true is applied to the cell. "Pattee" wrote: Column D is formated as follows ="TODAY()-90" so that if it is over 90 days past due the font will turn red... but I am trying to format it so that if I have text entered into column F it stays black as the format doesn't apply... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple conditional formats met | Excel Discussion (Misc queries) | |||
Multiple conditional formats | Excel Discussion (Misc queries) | |||
Multiple Conditional formats | Excel Worksheet Functions | |||
Apply multiple Conditional Formats | Excel Worksheet Functions | |||
how do i use multiple conditional formats in one cell? | Excel Discussion (Misc queries) |