Color change

Z

zeewaa

I would like the color to change in a cell if the result is greater than
another cell.

What I have is a cell(D21) that has added up a column of estimated dollar
figures (=Sum(D5:D20)). I than have a cell(E21) that add up a second column
of actual figures (=SUM(E5:E20)). what I want to do is to have cell E21 value
to show up in red if it is greater that cell D21.
 
R

Ruth

Make the E21 active - click on Format---- Conditional Formatting--
in the pop up box-- Choose ---Cell Value Is-- Greater than ---type in the
3rd box =$D$21... then click on Format -in the Font Tab choose red in the
color box- click OK than click ok in the Conditional Formatting Box
 

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