SOLVED

Excel Colouring cell nightmare

%3CLINGO-SUB%20id%3D%22lingo-sub-2556381%22%20slang%3D%22en-US%22%3EExcel%20Colouring%20cell%20nightmare%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2556381%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20getting%20to%20the%20stage%20when%20i%20will%20have%20no%20hair%20left%20to%20pull%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20put%20a%20spreadsheet%20toghter%20(See%20Below)%20to%20show%20employees%20training%20records%2C%20i%20have%20used%20%22Conditional%20Formatting%22%20to%20show%20if%20a%20course%20is%20in%20date%20(Normal)%2C%20going%20out%20of%20date%20(Orange)%20and%20expired%20(Red)%20but%20i%20also%20want%20to%20change%20the%20persons%20name%20to%20red%20if%20they%20have%20any%20course%20expired%20or%20orange%20if%20any%20are%20going%20out%20of%20date.%20any%20help%20would%20be%20greatfully%20received.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Demo%20PIC.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F296409i90DCAF5BA0F8D9FF%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Demo%20PIC.jpg%22%20alt%3D%22Demo%20PIC.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2556381%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2556508%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Colouring%20cell%20nightmare%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2556508%22%20slang%3D%22en-US%22%3EIn%20conditional%20formatting%20you%20will%20need%20to%20add%202%20new%20items%20with%20custom%20formulas%20both%20applied%20to%20the%20names%20(I%20think%20that%20would%20be%20A13%3AB50%20or%20maybe%20also%20include%20col%20C%3F)%3A%3CBR%20%2F%3Eformat%20red%3A%20%3DMIN(%24F13%3A%24M13)%3CTODAY%3E%3C%2FTODAY%3Eformat%20orange%3A%20%3DMIN(%24F13%3A%24M13)%26lt%3B%3DTODAY()%2B30%3C%2FLINGO-BODY%3E
New Contributor

Hi, I am getting to the stage when i will have no hair left to pull out.

 

I have put a spreadsheet toghter (See Below) to show employees training records, i have used "Conditional Formatting" to show if a course is in date (Normal), going out of date (Orange) and expired (Red) but i also want to change the persons name to red if they have any course expired or orange if any are going out of date. any help would be greatfully received.

 

Demo PIC.jpg

2 Replies
In conditional formatting you will need to add 2 new items with custom formulas both applied to the names (I think that would be A13:B50 or maybe also include col C?):
format red: =MIN($F13:$M13)<TODAY()
format orange: =MIN($F13:$M13)<=TODAY()+30
best response confirmed by frizz72 (New Contributor)
Solution

@mtarler 

Your a star, works like a dream.