formula to change font colour depending on which cell it has used
I have received some great help on here and again I am seeking more guidance
(sorry). I have been tasked with setting up some spreadsheets at work to on applications coming into my department and the number of days it takes for us to deal with them. I am also looking at number of written enquiries as well. Using the following headings Application Received (B4), Enquiry Received (C4), Completed Date (E4). Then using the following formula =NETWORKDAYS(IF(B4<"",B4,C4),E4,$A$119:$A$158) So that it will look at B4 determine if a date is in the cell if it isnt populated it looks at C4 instead whichever cell is completed it then works out the networkdays by looking at E4. The text within the $ signs refer to bank holidays listed on the spreadsheet Would it be possible to have anything in place that does that formula but depending on which cell was used (B4 or C4) it would provide the answer in a different coloured font? For example it works out which date it has to use for doing the networkdays and if its used the date in B4 when providing the answer (number of days)it remains normal font colour (black) and if it uses the date in C4 the answer turns red font. If so would someone be so kind in advising the formula I would need to use. Thanking you in advance |
formula to change font colour depending on which cell it has used
Its ok I have worked it out now although its now raised a new question which
I will post in a new topic. Thanking everyone that may have looked at it for me "Matt" wrote: I have received some great help on here and again I am seeking more guidance (sorry). I have been tasked with setting up some spreadsheets at work to on applications coming into my department and the number of days it takes for us to deal with them. I am also looking at number of written enquiries as well. Using the following headings Application Received (B4), Enquiry Received (C4), Completed Date (E4). Then using the following formula =NETWORKDAYS(IF(B4<"",B4,C4),E4,$A$119:$A$158) So that it will look at B4 determine if a date is in the cell if it isnt populated it looks at C4 instead whichever cell is completed it then works out the networkdays by looking at E4. The text within the $ signs refer to bank holidays listed on the spreadsheet Would it be possible to have anything in place that does that formula but depending on which cell was used (B4 or C4) it would provide the answer in a different coloured font? For example it works out which date it has to use for doing the networkdays and if its used the date in B4 when providing the answer (number of days)it remains normal font colour (black) and if it uses the date in C4 the answer turns red font. If so would someone be so kind in advising the formula I would need to use. Thanking you in advance |
All times are GMT +1. The time now is 05:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com