Web Based Data imports

technician

New Member
Joined
Jan 20, 2006
Messages
6
I have imported data into an excell sheet with ease, however i am having trouble with the conditional formatting side of the data.

How can i make the cell change a colour, while using web based queiries ???

I have tried "format, Conditional Formatting", and set the cell to

equal to ="r" but when R is in that cell the cell does not change colour

HELP
 

Some videos you may like

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,946
Office Version
  1. 365
Platform
  1. Windows
Paul

If it's R you are testing for why not use R?

="R"

If it's R or r you want to test for you would need to use a formula.

=UPPER(A1)="R"
 

Dufus

Board Regular
Joined
Aug 19, 2006
Messages
176
Are you using the "Cell Value Is" option or the "Formula Is" option?
 

Dufus

Board Regular
Joined
Aug 19, 2006
Messages
176
Using ="r" is not case sensitive and if you chose "Cell Value Is" "equal to" and ="r" in the dialog box you should get a result. I suspect that you have something else in the cells in addition to "r". Check for spaces and stuff.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,675
Messages
5,549,363
Members
410,911
Latest member
AniEx
Top