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 |
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 |
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 |
All times are GMT +1. The time now is 09:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com