If then color of cell

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
 
B

bumble78

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
 
M

Marcelo

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:
 
Top