|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 16th, 2004, 10:03 PM
|
|||
|
|||
Conditional formatting
Hello,
I am trying to write a conditional format formulae, but I am not getting any joy. I am using the 'Formula Is' as below =IF(L2TODAY(),"YES"," "), and I want a bold red font. All I am getting is a blank cell, L2 contains the date 15/05/2004. Help! Many thanks, Yinka 
|
|
#2
June 16th, 2004, 10:17 PM
|
|||
|
|||
|
Conditional formatting
Hi Yinka,
If you date were actually text instead of a number you get a space. Also the Conditional Formatting formulas generated are dependent on what cell was active when you entered the C.F. formulas. Conditional Formatting http://www.mvps.org/dmcritchie/excel/condfmt.htm -- --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Yinka" wrote ... I am trying to write a conditional format formulae, but I am not getting any joy. I am using the 'Formula Is' as below =IF(L2TODAY(),"YES"," ") , and I want a bold red font. All I am getting is a blank cell, L2 contains the date 15/05/2004.
|
|
#3
June 16th, 2004, 10:18 PM
|
|||
|
|||
|
Conditional formatting
Yinka,
Omit the IF. Simply put use, L2TODAY() then set the condition of a true result: Bold Red font. -- Regards... "Yinka" wrote: Hello, I am trying to write a conditional format formulae, but I am not getting any joy. I am using the 'Formula Is' as below =IF(L2TODAY(),"YES"," "), and I want a bold red font. All I am getting is a blank cell, L2 contains the date 15/05/2004. Help! Many thanks, Yinka
|
|
#4
June 16th, 2004, 10:46 PM
|
|||
|
|||
|
Conditional formatting
Thanks, will try it out.
"cincode5" wrote: Yinka, Omit the IF. Simply put use, L2TODAY() then set the condition of a true result: Bold Red font. -- Regards... "Yinka" wrote: Hello, I am trying to write a conditional format formulae, but I am not getting any joy. I am using the 'Formula Is' as below =IF(L2TODAY(),"YES"," "), and I want a bold red font. All I am getting is a blank cell, L2 contains the date 15/05/2004. Help! Many thanks, Yinka
|
|
#5
June 17th, 2004, 04:44 AM
|
|||
|
|||
|
Conditional formatting
-----Original Message----- Hello, I am trying to write a conditional format formulae, but I am not getting any joy. I am using the 'Formula Is' as below =IF(L2TODAY(),"YES"," "), and I want a bold red font. All I am getting is a blank cell, L2 contains the date 15/05/2004. Help! Many thanks, Yinka . Yinka, Your formula =IF(L2TODAY(),"YES"," "), will give a false answer, the Blank between your " ", ie L2 is not greater than today, if you want to know if L2 is less than today then change the to a and it should work. steve
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
