Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell contents depending on font colour | Excel Worksheet Functions | |||
Changing font colour depending on cell value | Excel Worksheet Functions | |||
formula to change font or cell colour | Excel Worksheet Functions | |||
How to change a cell colour depending on the result? | Excel Programming | |||
Change colour of cell depending on content | Excel Programming |