| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 2911 | 1999-11-02 05:28:00 | Change Color of cell using formula | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 3323 | 1999-11-02 05:28:00 | I have created an IF statement in an excel 97 spreadsheet: =IF(DAY(F5)<=7,0&2&(2*((YEAR(F5)-1998)*12+MONTH(F5)-10)),(MOD(F5-36480-(INT((F5-36479)/7)*2),52))+1002) Which returns a particular value depending on whether it is the first friday of the month or not. Is there any way to also change the colour of the contents to red if the statement is true (without using macros)? |
Guest (0) | ||
| 1 | |||||