Hi, can anyone help me with this?
can we write a formula with multiple conditions to apply conditional formatting.
when multiple conditions are met. the cell should be applied red.
I have applied the conditional formating in the cell C2. the formating is not applied.
IF(AND($A$2=""No"",$B$2=""Yes"") -- when this condition is met, I want the C2 cell to turn to Red. sample sheet attached
highlight cell C2, go to conditional formating - Manage rules to edit the formula.
hi there. a few things:
1. your formula is wrapped around with double quotes. remove them. when i went in the rules, it was:
="IF(AND($A$2=""No"",$B$2=""Yes""))"
2. you only need to put in 1 double quotes, before & after a text. so "No" and not ""No""
3. IF is to say that if the condition is met, put something. you only need the logical test for it to work. to use IF, it is something like:
=IF(AND($A$2="No",$B$2="Yes"),TRUE,FALSE)
but you can simply use:
=AND($A$2="No",$B$2="Yes")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks