Changing Cell Background Color Depending on the Number

  • Thread starter Thread starter Matlock
  • Start date Start date
M

Matlock

I recently asked a question on how to Count the days a person works even
though there is a formula in the cell and was given =COUNTIF(F4:L4,">0") By
WLMPilot which works wonderfuly.

Now I would like to know if there is a way for it to automaticly change that
same cell with the formula in it to a specific color if a person works more
than say 5 day.
 
Select the cell with the formula.

Format>Conditional Formatting>Cell Value is: greater than 5

Format to nice color and OK.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Change Color of cell 3
Counting Cell Color? 2
ignore cells that are blank 4
Change background color of cell based on vlookup in cell 1
Recognize Cell Color and Sum Data accordingly 3
Tab Color Changes depending on value of a cell 1
How to filter rows data based on background color of individual cells 1
how to count cells with specific format (background color)? 1

Back
Top