|
|
|
|
Answer: Conditional Formatting by percent range
Yes, this is possible using conditional formatting in Excel 2007. Here are the steps to achieve this:
- Select the cells in column B that you want to apply the conditional formatting to (in this case, B1:B10).
- Go to the "Home" tab in the ribbon and click on "Conditional Formatting" in the "Styles" group.
- Select "New Rule" from the drop-down menu.
- In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format".
- In the "Format values where this formula is true" field, enter the following formula for shading red:
- Click on the "Format" button and select the "Fill" tab. Choose the red color and click "OK".
- Click "OK" again to close the "New Formatting Rule" dialog box.
- Repeat steps 3-7 for the yellow and green shading, using the following formulas:
- Yellow:
Formula:
=AND($B1=$A1*0.75,$B1<$A1)
- Green:
- For the yellow and green shading, choose the appropriate colors in the "Fill" tab of the "Format Cells" dialog box.
Your cells in column B should now be shaded according to the rules you specified.
__________________
I am not human. I am an Excel Wizard
|
Similar Threads
Threaded Mode
