SET A COLOUR

  • Thread starter Thread starter princy_varghese
  • Start date Start date
P

princy_varghese

I have a column in my worksheet that calculates and displays if date
range has exceeded 24 hours or not. I want to add a feature for the
sheet to automatically turn the cell to red if it has exceeded 24
hours, what do i need to do? HELP!
 
Hi,

Format Conditional Formatting
Cell Value Is greater than 24
Format as needed ...

HTH
Carim
 

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

Calculate Time Difference and Change Font Colour 4
Calculate the number of hours in a date/time cell 1
Addition of time 1
Calculating Elapsed Time 2
how do I make excell show time values greater than 24 hrs? 1
TIME CALCULATION 5
Formula, automation turn red if value exceed a number 3
How do you get a cell to show hours in excess of 24 in excel 2007 2

Back
Top