ExcelBanter - SET A COLOUR

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - SET A COLOUR (https://www.excelbanter.com/excel-worksheet-functions/115127-set-colour.html)

SET A COLOUR

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!

Carim

SET A COLOUR

Hi,

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

HTH
Carim

All times are GMT +1. The time now is 05:33 PM.