Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional Formatting problem
I want to know if I can conditionally format cells in a column of data which
end with a full stop - i.e if this is a column of data I want to be able to highlight... blue. - highlight Yellow red. - highlight black brown green. - highlight Any ideas????? |
#2
|
|||
|
|||
select the cells, and then use CF with Formula Is and a formula of
=RIGHT(A1,1)="." format as required. This assumes the data is column A, starting in A1 -- HTH RP (remove nothere from the email address if mailing direct) "Cumbo" wrote in message ... I want to know if I can conditionally format cells in a column of data which end with a full stop - i.e if this is a column of data I want to be able to highlight... blue. - highlight Yellow red. - highlight black brown green. - highlight Any ideas????? |
#3
|
|||
|
|||
One way:
CF: Formula is =RIGHT(A1)="." In article , "Cumbo" wrote: I want to know if I can conditionally format cells in a column of data which end with a full stop - i.e if this is a column of data I want to be able to highlight... blue. - highlight Yellow red. - highlight black brown green. - highlight |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting in Charts? | Charts and Charting in Excel | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
How do I get more than 3 Conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting (Date vs Number) | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) |