Conditional formatting

  • Thread starter Thread starter Ramon Mendoza
  • Start date Start date
R

Ramon Mendoza

How can I apply a conditional format to a cell whenever 2 conditions are met?

Let's say, for example, I want cell A1 to be colored red if cells A3="Yes"
and A6<>0. But only if both are met, otherwise color it green.

Thank you.
 
I forgot to ask if it also possible to drag that conditional formatting along
with the formula to the rows below.
 
Hi Ramon
If you would like the CF on more then 1 cell, just select the range then
goto Conditional Formatting, choose Formula is: and type this in
=AND(A3="Yes",A6<>0)>goto Format >Choose colour. Thay it...
HTH
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically change the text format the cell when use a specific text 10
Data Validation and drop-down list using IF, AND and what else? 8
Conditional formatting in Excel_Strange behaviour 6
Conditional Formatting Question 2
Conditionnal formatting 1
CONDITIONAL FORMATTING QUERY 0
Conditional Formatting 1
Conditional format question 4

Back
Top