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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|