Conditional Formatting on cells beginning with a hyphen

  • Thread starter Thread starter Greg Lovern
  • Start date Start date
G

Greg Lovern

Is it possible to do conditional formatting on cells beginning with a
hyphen?


Thanks,

Greg
 
1. Place the cursor in A1 cell and select the Range
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and paste the below formula
=LEFT(A1,1)="-"
4. Click Format Button>Font>Color select your desired font & Background
Color pattern and then give ok

Change the cell reference of A1 to your desired cell, if required.

But keep in mind that when applying the conditional formatting the Active
cell should be in the cell on which the formula is referred.

For Example if you want to apply the conditional formatting for C Column
when the formula is referring the C2 cell then place the cursor in C2 cell
and select the whole C Column by pressing Cntrl+Spacebar and apply the below
formula.
=LEFT(C2,1)="-"

If this post helps, Click Yes!
 
Hi Greg,

In my tests I have two possibilities.

Idea one:

Select the cells to be formatted.
Then Format>Conditional format>Cell value is>Less
than>0>Format>Patterns>'select a color'>OK out.

Idea two:

Select the cells to be formatted.
Then Format>Conditional format>Formula
is>=IF(LEFT(B1,1)="-",2)>Format>Patterns>'select a color'>OK out.

HTH
Regards,
Howard
 
3. For Condition1>Select 'Formula Is' and paste the below formula
=LEFT(A1,1)="-"
But keep in mind that when applying the conditional formatting the Active
cell should be in the cell on which the formula is referred.
Click to expand...

Thanks! :-)

Greg
 
Back
Top