Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
Cell color based upon cell value | Excel Discussion (Misc queries) | |||
cell color index comparison | New Users to Excel | |||
up to 7 functions? | Excel Worksheet Functions |