Excel Conditional Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1812086%22%20slang%3D%22en-US%22%3EExcel%20Conditional%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1812086%22%20slang%3D%22en-US%22%3EHi.%20I%20want%20a%20cell%20to%20be%20highlighted%20if%20I%20have%20spent%2070%25%20or%20more%20of%20a%20years%20budget.%3CBR%20%2F%3E%3CBR%20%2F%3EEg%3CBR%20%2F%3E1000-800%3D200(%20therefore%20I%20want%20this%20cell%20to%20be%20filled%20red%20to%20alert%20me%20I%20have%20spent%20over%2070%25of%20my%20yearly%20budget.%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20anyone%20tell%20me%20how%20to%20do%20this%20correctly%3F%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1812086%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1812401%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Conditional%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1812401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F843507%22%20target%3D%22_blank%22%3E%40Katlee2020%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20this%20help%20or%20dont%20you%20want%20the%20extra%20column%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22cond%20format.JPG%22%20style%3D%22width%3A%20859px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F228727i59411DE4638ECEED%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22cond%20format.JPG%22%20alt%3D%22cond%20format.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
Hi. I want a cell to be highlighted if I have spent 70% or more of a years budget.

Eg
1000-800=200( therefore I want this cell to be filled red to alert me I have spent over 70%of my yearly budget.

Can anyone tell me how to do this correctly??
2 Replies

@Katlee2020 

Does this help or dont you want the extra column

 
 

cond format.JPG

 

@Katlee2020 

 

Or try this

 

cond format.JPG