Graphical Indicators Formula

G

Gary

Hi all, is there any formula you can use within Excel, that if true or false
throws up some sort of graphical indicator like in Project.

For example, if you were testing if you had say spent 50% or more of an
available budget figure, a certain formula in excel would throw up a red
graphical indicator or maybe just turn that particular cell red?

Regards

Gary.
 
D

Dennis

Highlight your cell or cells then select
Format - Conditional Formatting
Enter the condition to check for and then format the cell colour based on
the result
 

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

Top