Conditional formatting for UPPER case

[mnmhenry]

Hi there,
Can I change text color by way of conditional formatting for a cell that has CAPITOL LETTER.

Lower case can stay as the default, but when the cell holds upper case text (a sub heading) I would like it to be red.

Thanks in advance & "up the mighty blues!"

 

[mikerickson]

Use the Conditional Formatting formula

=(A1=UPPER(A1))

 

[jim may]

Use FormulaIS:

=EXACT(A1,UPPER(A1))
Pattern Red,

OK, OK

 

[mnmhenry]

Thankyou, they work a treat. Bless you all