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
 
try conditional formating

hth
regards from Brazil
Marcelo

"bumble78" escreveu:
 
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:
 
You must log in or register to reply here.

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