IF THEN HIGHLIGHT

pistol1

New Member
Joined
Dec 27, 2003
Messages
10
I would like to perform a if then function that if a letter say d is entered in a cell then the row is highlighted in transparent red. Could anyone help me with this matter I would greatly appreciate it .
Thanks Pistol1
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831
And methinks you're after conditional formatting - check the xl help files...
 

pistol1

New Member
Joined
Dec 27, 2003
Messages
10
I looked at the conditional format help. I can't seem to reference a single cell to highlight a whole line. I will keep trying any suggestions would be apprecialted thanks Pistol1 :oops: does anyone recomend a good learning resource for me to master excel. I would like some suggestions.
 

Iridium

Well-known Member
Joined
Jul 15, 2002
Messages
2,831
Enter the conditional format for cell A1:

'Formula is' =$A$1=1

Copy it and select row A and pastespecial formats....

Edit: enter 1 in A1 and the row should hghlight - try something else and it should'nt
 

GorD

Well-known Member
Joined
Jan 17, 2004
Messages
1,446

ADVERTISEMENT

you can use the conditional formating from the format menu as suggested. Make sure that the cell you are referring to for the condition is locked i.e $a$1 . You can then use the format painter (double click the paint brush) to copy the format out as many columns as you need (does quite do the whole row, but may be good enough).

Hope this helps
 

pistol1

New Member
Joined
Dec 27, 2003
Messages
10
I appreciate the help I was only able to get the cell to highlight. now I should be able to get the whole row. My value is in collumn c do I just sub c for a thanks for the help and advice Pistol :p
 

Noir

Active Member
Joined
Mar 24, 2002
Messages
362
Hello Pistol1,

Here is another Conditional Formatting option for you.

1) In a cell, say F1, type: =Countif($C$1:$C$50,"d")
2)Select C1 with mouse, go to “Format”, Conditional Formatting, with "Condition1" as "Formula is", type: =$F$1>0. Format color as desired (Don't think you can get transparent red in Conditional Formating though. Someone will correct me if i'm wrong)
3)Copy C1, drag down to C50, go to “Edit”, “Paste Special”, “Formats” , OK

The formula will scan C1:C50, looking for a "d". When the first "d" is entered, the formula will produce a value of "1". At this point the Conditional Formatting will have justification to highlight your specified range (C1:C50) to your specified color (Red).

HTH

Noir
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,822
Messages
5,772,467
Members
425,760
Latest member
paphon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top