basic conditional formatting

[jdmc45]

Hi,

I have a question re conditionally formatting. It never seems to work for me!
I have data in a spreadsheet from column A to G, and want to highlight column C value for different text and only column C. They are currencies, so for AUD I'd like coloured orange, for EUR, blue, USD red, etc. And only that cell I want coloured, not the whole row.

Can someone help me please?

 

[VoG]

Perhaps this will help http://www.contextures.com/xlCondFormat01.html

 

[jdmc45]

Perhaps this will help http://www.contextures.com/xlCondFormat01.html

Thanks for the quick reply. I had a look that website doesn't address my issue. And I am using Excel 2007. Anyone can help?

I have tried

=INDIRECT("C"&ROW())=AUD

then fill orange, etc. Doesn't work.

Also tried

="AUD"

then fill orange, etc. Doesn't work.

Any help is appreciated, cheers!

 

[VoG]

You are overcomplicating this. Select the values in column C, Conditional Formatting > New Rule > Format only cells that contain > select Equal to > enter AUD > click Format, apply a format > click OK.

 

[jdmc45]

You are overcomplicating this. Select the values in column C, Conditional Formatting > New Rule > Format only cells that contain > select Equal to > enter AUD > click Format, apply a format > click OK.

thanks for that, the conditional formatting toolbar is not very intuitive for me.

Cheers!