This is a blog which will post useful infomation about fixing computer errors. To help people troubleshoot errors, speed up computers and share good apps.


[Anwsered] Adding text string to conditional formatting formula?

Adding text string to conditional formatting formula?

I *think* I have one condition in conditional formatting okay.  If a condition is true, I believe the formula below will change cell colours and will display the text "To Do Today:" in B3:
=WEEKDAY((B4)=6, "To Do Today:")
At least, I get no error and the formula is accepted in condition 1.
In condition 2, I just can't place those parentheses so that they take.  Ideally, the text string displayed if the condition is true as "To do this coming Friday:":
Formula:  =NOT(WEEKDAY(B4)=6)
Text string:  "To do this coming Friday:"
But I get errors all the time no matter what I do.  And I've googled and googled.  Nothing has come up so far.
Thanks for any help in this regard.

Anwsers to the Problem Adding text string to conditional formatting formula?

Download Error Fixer (Free)

Conditional Formatting will not display text as a output.
 The formula  does not generate an output, only a True/False value used to apply formatting.

You need to do this in 2 separate steps

First put the formula =IF(Weekday(B4)=6,"To Do Today:","To do this coming Friday:") in cell B3
Then set your conditions
Condition 1 Cell value="To Do Today:" and pick your formatting
Condition 2 Cell Value="To do this coming Friday:" and pick another format to use.

  • Download the Microsoft Windows ISO (installation device) from the following website:
  • Users must select the appropriate ISO, either 32 bit or 64 bit, depending upon their individual computer.
  • Extract the ISO file to a separate USB device or burn the program to a compact disc.
  • Run the Microsoft Windows 10 upgrade directly from the software that you have thus created.

Recommended Method to Fix the Problem: Adding text string to conditional formatting formula?:

How to Fix Adding text string to conditional formatting formula? with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer.  Open it, and it will perform a scan for your system. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems need to be fixed. Click Fix All.

3. When the Fixing part is done, your computer has been speeded up and the errors have been fixed

Related: How to Fix - 64g ssd with a 500g regular drive?,Allow Unhide Rows in Protected Workbook [Solved],[Solved] Get in Excel 2007 data from Access 2007 out of self-built Queries,[Solution] How can I temporarily disable 'service manager' to install Adobe flashplayer?,[Anwsered] When I try to watch a flash video, I am told occasionally that I don't have Adobe Flash.,Solution to Error: Black screen during boot sequence,[Solved] Can't restore Windows 7 64-bit from external hard drive,How to Fix - IE 11 Enhance Protect Mode reset issue with add-on's?,Solution to Error: Internet Explorer 9 update/install error - Error Code 80092004,Upgrading to IE 8 causes cookies to get deleted when starting IE [Anwsered],Solution to Problem: All programs try to start from windows component
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: How Can I Fix - After I've clean installed Windows 7 will I need to download\/buy something to play DVDs and CDs??,After I shut down my computer running Windowa 7, it re-starts on it'e own a short time later [Anwsered],Troubleshoot:Adding second y-axis to pivot chart,Troubleshooting:After curing a virus, I can no longer download PDF files. any help? Error,How to Fix - After computer was infected with win32\/cutwail.BA virus computer is very slow at startup?,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded


Post a Comment

Note: Only a member of this blog may post a comment.

Sample Text

Copyright © Fix Your PC Errors & Speed Up Your PC | Powered by Blogger Design by ronangelo | Blogger Theme by