ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Formatting (https://www.excelbanter.com/excel-discussion-misc-queries/243486-conditional-formatting.html)

Loren

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

Eduardo

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


Luke M

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