Conditional Formatting in Excel

A

Arne

I would like a cell to change color when a range of other cells all have a
value entered.
The cell I want to automatically format has the Sum function for a range of
cells in it. When the range of cells that are being being used for the Sum
function all have a value entered I would like the cell with the Sum to
change either background color or font color. Is there an easy way to do this?
 

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

Excel VBA 1
Conditional Formating in Excel 5
Excel Macro to automatically go to the right of the last colored cell 0
Excel conditional formatting with Weeknum 4
Conditional Formatting with VBA 4
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel Conditional Formatting Removal 7

Top