Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting for Dummies
Hi, I have a cell in a spreadsheet that I want to colour orange when certain things happen. I have tried and tried to do the formula (which i don't think is that hard) but i can't get the cell to change colour. I will describe the formula a need to plain english below. Any help you could give me would be great. M17 = Date Completed N17 = Date Required P2 = Today() My formula needs to say: If M17 = 0 (uncompleted) and N17 is greater than today (P2) then go orange. Hope this makes sense.! Cheers, Phil |
#2
|
|||
|
|||
Select cells of interest
<format<conditional formating change "cell value is" to "formula is" formula is =and(M17=0,N17$P$2) Set the patern format to orange note I often need to go back into the conditinal format section to remove unwanted Quote marks and make sure my references stay absolute or relative as wanted. Why they change from what I want sometimes, I have no clue. "PW11111" wrote: Hi, I have a cell in a spreadsheet that I want to colour orange when certain things happen. I have tried and tried to do the formula (which i don't think is that hard) but i can't get the cell to change colour. I will describe the formula a need to plain english below. Any help you could give me would be great. M17 = Date Completed N17 = Date Required P2 = Today() My formula needs to say: If M17 = 0 (uncompleted) and N17 is greater than today (P2) then go orange. Hope this makes sense.! Cheers, Phil |
#3
|
|||
|
|||
One way:
CF1: Formula is =AND(M17=0,N17P2) Format1: <patterns/<orange In article , "PW11111" wrote: Hi, I have a cell in a spreadsheet that I want to colour orange when certain things happen. I have tried and tried to do the formula (which i don't think is that hard) but i can't get the cell to change colour. I will describe the formula a need to plain english below. Any help you could give me would be great. M17 = Date Completed N17 = Date Required P2 = Today() My formula needs to say: If M17 = 0 (uncompleted) and N17 is greater than today (P2) then go orange. Hope this makes sense.! Cheers, Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |