Conditional Formatting - Not working

[pskwaak]

Have a range of rows/columns with various numbers entered. Initiated conditional formatting, but won't format until I re-enter each individual number. Rules are correctly entered, format is set for number. Tried copy/paste format, didn't work. What can I do to keep from re-entering each number?

Thanks!

[Vikas_Gautam]

Try copy and pasting values...

or provide us a sample workbook.. to help you better...


Don't forget to click *

[pskwaak]

Tried that also, didn't work. Not sure how to attach spreadsheet to this reply?

[Vikas_Gautam]

Click GO Advance and click Manage attachments and upload your file...

Don't forget to click *

[pskwaak]

OK, here's what I have set up: Position Ratings.xlsx

[martindwilson]

some are text some aren't
i'd just select the columns a:j format general
then select each column in turn
data/text to columns click finish repeat for each column