Conditional Formatting

Susan Miller

Hi -

Trying to replicate this Excel Conditional format that runs based on a calculation off another column...

So if Column A is less than 95% of Column B...light up Column A...

Any guidance is appreciated...

Nic Larsen

You could just create a helper column to do the math portion of finding what % B is to A. Then use conditional formatting to highlight your Column B if it meets the %.

Nic Larsen

You could just create a helper column to do the math portion of finding what % B is to A. Then use conditional formatting to highlight your Column B if it meets the %.

Susan Miller

Thanks Nic! That is what i ended up doing...