Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-06-2017, 09:29 AM
Diana09 Diana09 is offline How to use conditional formatting for two criteria? Windows 10 How to use conditional formatting for two criteria? Office 2013
Novice
How to use conditional formatting for two criteria?
 
Join Date: Dec 2017
Posts: 3
Diana09 is on a distinguished road
Default How to use conditional formatting for two criteria?

Hello



I would like to use conditional formatting (or other hypothesis) for the following:
If one cell has "yes" and the other has "-", format with red color. I'm not getting.
I tried the formula: If in the cell has "yes" and in the other has "-", write in another cell "no" and based on this "no", format in red. But I didn't want it to be like this.

Thank you for your attention and for your help.
Reply With Quote
 

Tags
conditional formatting, two criteria



Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting chrisoconn Excel 0 07-05-2017 02:10 AM
How to use conditional formatting for two criteria? Conditional formatting bbutl027 Excel 15 12-05-2016 08:56 PM
Conditional Formatting sdfrance Excel 3 01-06-2015 07:10 AM
How to use conditional formatting for two criteria? Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
How to use conditional formatting for two criteria? Conditional formatting with AND, OR Lucky Excel 2 10-03-2011 11:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft