Time formula if great than 15

[Patriot2879]

Hi i hope you can help i would like a formula please. i have cell A1 which time stamps todays date and time when data is inputted in another cell. B1 has a 'yes' or 'no' in a list which gets selected. What i require is when A1 is updated with a time stamp and cell B1 = 'Yes' i want cell C1 to put in the time for when B1 was updated. Then in D1 i want a calculation to work out the time difference between cell A1 and C1 and if this is greater than 15 i want cell A1 to change to red colour. I hope this all makes sense and that you can help please?

 

[Patriot2879]

Hi thank you for that it works now, but it doesn't automatically update if another cell turns red, is there any way to do that, or do i have to refresh the Countcolours code?

 

[CountTepes]

A change in colour is not classed as a cell change, only when the contents change.

Press F9, to recalculate the sheet.

 

[Patriot2879]

that works great thank you, much appreciated

 

[CountTepes]

One other thing. The Colours Red, Cyan, etc, are all based on a ix of the RGB colours of each being 255 or 0. No shades.

If you want to work in shades of colour, put in the numerical value instead of the name of the colour. So light Green will be 5296274, which is Red = 146, Green = 208 and Blue = 80

 

[Patriot2879]

brilliant thank you this is working great now much apprecaited