If then color of cell
 

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


--
bumble78
------------------------------------------------------------------------
bumble78's Profile: http://www.excelforum.com/member.php...o&userid=36373
View this thread: http://www.excelforum.com/showthread...hreadid=563035

If then color of cell
 

try conditional formating

hth
regards from Brazil
Marcelo

"bumble78" escreveu:


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


--
bumble78
------------------------------------------------------------------------
bumble78's Profile: http://www.excelforum.com/member.php...o&userid=36373
View this thread: http://www.excelforum.com/showthread...hreadid=563035

If then color of cell
 

Use Conditional Formatting.

"bumble78" wrote:


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


--
bumble78
------------------------------------------------------------------------
bumble78's Profile: http://www.excelforum.com/member.php...o&userid=36373
View this thread: http://www.excelforum.com/showthread...hreadid=563035

If then color of cell
 

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


--
bumble78
------------------------------------------------------------------------
bumble78's Profile: http://www.excelforum.com/member.php...o&userid=36373
View this thread: http://www.excelforum.com/showthread...hreadid=563035

If then color of cell
 

hi,

format | conditional format | change to the formula is

eg
=if(a115)

choose the format and click OK

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


--
bumble78
------------------------------------------------------------------------
bumble78's Profile: http://www.excelforum.com/member.php...o&userid=36373
View this thread: http://www.excelforum.com/showthread...hreadid=563035

If then color of cell
 

Thanks! It worked for me.:)


--
bumble78
------------------------------------------------------------------------
bumble78's Profile: http://www.excelforum.com/member.php...o&userid=36373
View this thread: http://www.excelforum.com/showthread...hreadid=563035

If then color of cell
 

thanks for the feedback,

glad to help you
Marcelo

"bumble78" escreveu:


Thanks! It worked for me.:)


--
bumble78
------------------------------------------------------------------------
bumble78's Profile: http://www.excelforum.com/member.php...o&userid=36373
View this thread: http://www.excelforum.com/showthread...hreadid=563035