formatting
If I have a sheet which in one column has targets and in the next has
actuals, how can i enter one type of conditonal formatting to ensure it colours depending on result? Jez |
Jez
Assuming you want to color an actual if it doen't meet target. Assuming targets are in column A and actuals in column B. Select column B or as much of column B as you need. FormatCFformula is: Condition one....=IF($B1="","",$A1$B1) format to blue Condition two....=IF($B1="","",$A1<$B1) format to red Gord Dibben Excel MVP On Fri, 28 Jan 2005 13:19:01 -0800, Jez wrote: If I have a sheet which in one column has targets and in the next has actuals, how can i enter one type of conditonal formatting to ensure it colours depending on result? Jez |
All times are GMT +1. The time now is 10:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com