Conditional Formating based on a "S"

E

Earl Kiosterud

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.
 
D

David McRitchie

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.
 
A

All Star

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

David said:
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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

Earl Kiosterud said:
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.
Click to expand...
Click to expand...
 
D

David McRitchie

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
 
Top