![]() |
Conditional Formatting
Is there any way to set up your conditional formatting to go to BOLD if your
value in that square is above or below the value you desire? I.E. in cell BF32 if the value is below 13 or above 17 I want the cell to have red font which I can do but if the font is red I want it to be bold and if its still black I want it to stay regular. -- Thanks, Loren |
Conditional Formatting
Hi,
go to conditional formating, rule value greater than, then click in format, font, choose bold and red if this helps please click yes thanks "Loren" wrote: Is there any way to set up your conditional formatting to go to BOLD if your value in that square is above or below the value you desire? I.E. in cell BF32 if the value is below 13 or above 17 I want the cell to have red font which I can do but if the font is red I want it to be bold and if its still black I want it to stay regular. -- Thanks, Loren |
Conditional Formatting
When you seutp the CF, on the same screen where you choose font color you can
choose font style. So, have the rule make the text red AND bold in the same step. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Loren" wrote: Is there any way to set up your conditional formatting to go to BOLD if your value in that square is above or below the value you desire? I.E. in cell BF32 if the value is below 13 or above 17 I want the cell to have red font which I can do but if the font is red I want it to be bold and if its still black I want it to stay regular. -- Thanks, Loren |
All times are GMT +1. The time now is 06:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com