Conditional Formating based on a "S"

  • Thread starter Thread starter All Star
  • Start date Start date
Wayne,

Select your cells (to be bolded). The active (white) cell should be in row
2 for the following formula. Format - Conditional Formatting - Formula is:
=$Q2="S"

Adjust the 2 in $Q2 to match the row of the active cell of the selection.
 
Hi Wayne,
Thanks, I've bolded in black or red wording for Conditional
Formatting applying to entire rows on my web page for future
readers.
 
Awesome examples page. Except there was no example of a text based CF
like I was looking for. Tons of dates and numbers comparison, but not on
a character.

Thanks for the formula, I got it working and my 30 page report now has
subtotal rows Bolded.

Awesome.
Thanks,
Wayne
 
Hi .......,
You're welcome.

Some Examples of Text Comparison in Conditional Formatting
contained in http://www.mvps.org/dmcritchie/excel/condfmt.htm

There isn't a real simple comparison
=A1="Total" -- not case sensitive

but there are the following text comparisons for C.F.:

Contains P.O. Box, or variations POBox, Post Office Box, PO Box, and others, Jason Morin in Worksheet.Functions
=NOT(ISERROR(SEARCH("*P*O*Box*",A1)))
-- SEARCH is not case sensitive, FIND is case sensitive

Duplicate Lastname in column with "Lastname, Firstname": Peo Sjoblom 2002-05-06
=COUNTIF(A:A,"="&LEFT(A1,FIND(",",A1))&"*")>1
-- several other duplicate tests as well.

Exact Comparison case sensitive
=EXACT(A1,"McRitchie")

FIND string in Cell A1 anywhere in cells of Column A
=AND(SEARCH($A$1,$A1),ROW()>1,$A$1<>"") -- case insensitive allows wildcards
=AND(FIND($A$1,$A1),ROW()>1,$A$1<>"") -- case sensitive

Looks Blank or ISBLANK -- the equivalent VBA formula is ISEMPTY
=TRIM(A1)="" -- looks blank
=ISBLANK(A1) -- actually is blank, no constants no formulas
=TRIM(A1)<>"" -- does not look blank
=NOT(ISBLANK(A1)) -- actually not blank, may contain formulas

Row is colored, if word "total" appears anywhere within any cell on the row. (wildcards).
Ctrl+A, with A1 or any cell on row 1 selected
=COUNTIF(1:1,"*total*") -- Jason Morin, worksheet.functions, 2003-08-01
 
Back
Top