Colour change depending on result

S

SimoninParis

Hi all,

Is it possible to make the true result of an IF statement, say, green and
the false result, say, red? I would like to be able to do this without using
VBa s I have no experience of using it.

Simon
 
P

piyush

just go to conditional formatting on the formats menu and use the options..
give the variables and u will get your results !!

piyush
 

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

Program buttons to create a word document 0
Excel does not accept text format! 0
VBA word change keys 0
Counting Cells with Conditional Formatting 7
VBA for Dependents shortcut menu 0
Page numbering with Merged Document and IF statements 1
Cell colour change if formula displays false 3
Copying the colour of one cell to anothers. 0

Top