Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help adding a formula to to cell with conditional formatting
Hi,
I have a cell with the following conditional formatting =AND(S2<TODAY(),W2="",D2="x") If these conditions are met the cell S2 is bolded in red. I need to add the following to the cell "if the date in U2 is earlier than the date in S2 then bold S2 in black" S2 and U2 are calendar dates. Could somebody help me with a formula for the above and how to add it to the existing formula? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help adding a formula to to cell with conditional formatting
If you want to use the formula as an another condition the use the below:-
=AND(U2<"",S2<"",U2<S2) If you want to use it in your present formula then use the below:- =AND(S2<TODAY(),W2="",D2="x",U2<S2) Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Max" wrote: Hi, I have a cell with the following conditional formatting =AND(S2<TODAY(),W2="",D2="x") If these conditions are met the cell S2 is bolded in red. I need to add the following to the cell "if the date in U2 is earlier than the date in S2 then bold S2 in black" S2 and U2 are calendar dates. Could somebody help me with a formula for the above and how to add it to the existing formula? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help adding a formula to to cell with conditional formatt
That works!
Thanks Max "Ms-Exl-Learner" wrote: If you want to use the formula as an another condition the use the below:- =AND(U2<"",S2<"",U2<S2) If you want to use it in your present formula then use the below:- =AND(S2<TODAY(),W2="",D2="x",U2<S2) Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Max" wrote: Hi, I have a cell with the following conditional formatting =AND(S2<TODAY(),W2="",D2="x") If these conditions are met the cell S2 is bolded in red. I need to add the following to the cell "if the date in U2 is earlier than the date in S2 then bold S2 in black" S2 and U2 are calendar dates. Could somebody help me with a formula for the above and how to add it to the existing formula? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help adding a formula to to cell with conditional formatt
You are welcome and thanks for feeding back.
-------------------- (Ms-Exl-Learner) -------------------- "Max" wrote: That works! Thanks Max "Ms-Exl-Learner" wrote: If you want to use the formula as an another condition the use the below:- =AND(U2<"",S2<"",U2<S2) If you want to use it in your present formula then use the below:- =AND(S2<TODAY(),W2="",D2="x",U2<S2) Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Max" wrote: Hi, I have a cell with the following conditional formatting =AND(S2<TODAY(),W2="",D2="x") If these conditions are met the cell S2 is bolded in red. I need to add the following to the cell "if the date in U2 is earlier than the date in S2 then bold S2 in black" S2 and U2 are calendar dates. Could somebody help me with a formula for the above and how to add it to the existing formula? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting a cell that has a formula | Excel Worksheet Functions | |||
Conditional formatting if a cell contains a formula | Excel Worksheet Functions | |||
Conditional formatting to a different cell and it contains a formula | Excel Worksheet Functions | |||
Conditional Formatting - adding condition on formula | Excel Discussion (Misc queries) | |||
Conditional Formatting on cell with a formula | Excel Worksheet Functions |