If then color of cell

  • Thread starter Thread starter bumble78
  • Start date Start date
B

bumble78

Hi, I am fairly new to both excelling, but have been lurking here for a
while. I have used the search to find some good info about how to do
some if/then functions and the checkmark application. My next issue is
I would like the colors of the cells to change color if they have a
checkmark in them, like green in one collum and red in the next. Is
this posible and if so how?

Thanks for all your help.


Joe
 
I used the checkmark trick, how would I make the conditional formating
work for any value? Thanks for the help, I had never heard of
conditional formating before, it is a fun toy.:)



Joe
 
hi,

format | conditional format | change to the formula is

eg
=if(a1>15)

choose the format and click OK

hth
regards from Brazil
Marcelo

"bumble78" escreveu:
 

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

How to extract separated text by many commas in Excel? 0
Excel VBA - counting cells by colors and names to it in two different rows. 0
Function for summing or counting cells based on a specified fill color 2
Conditional formatting dates 3
Sum Column Based on Cell Color 5
IF Then HELP!!!! 1
Excel Change tab color in Excel with Conditional Formatting formula in a cell 0
Conditional Sum Based on Cell Background Color 6

Back
Top