I would like some help with conditional formatting
I have a row with four cells in it
.
I would like the cell at the beginning of the row (column A) to become red if the
value of the last cell in the row (column D) is greater than or equal to 7:00
I would also like the cell at the beginning of the row (column A) to become yellow
if the value of the last cell in the row (column D) is less than 7:00
Any idea?
Thank you!
Use this conditional formatting formula and apply it to column A
and set format to red shading
Please Login or Register to view this content.
and set format to yellow shadingPlease Login or Register to view this content.
Happy with my advice? Click on the * reputation button below
Just an observation - your title indicates that you are dealing with minutes and seconds. Just be aware that Excel is treating entries like 7:00 etc as hours and minutes, not minutes and seconds. That in fact is why Crooza's formula works.
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
Good morning, thank you for the advice. the formula =$D1>=7/24 for red shading is working, but it seems to be superceding the formula =$D1<7/24 for yellow shading. Cells with the value
less than 7:00 (for example 6:45 or 5:30) are not yellow they are red too.
Any thoughts?
See the attached picture. Your implementation should look very similar.
CF3.png
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks