Help! Conditional Formating Formula

CJANG

New Member
Joined
Dec 26, 2005
Messages
3
I like to create a conditional formating formula that could help me highlight the entire row or column if one of the cell is T or F.

Example: If A1 is = T, then highlight A1:A20 in Color or the entire row in Color. IF A1 is = F, then do nothing.



Thanks!
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
Highlight A1:A20, go to Conditional Formatting,
Change "cell value is" to "formula is"; in the bar on the right, type =A1="T". Select the format you want.
 
Upvote 0
Gobias: Thanks for you quick reply. This is not exactly what I wanted. The formula you gave me will just highlight the cell(s) with "T" in it.

Here's what I am trying to do:

A B C D
1 Condition Vender Amount Date
2 T ABC 750 1/1/2006
3 F XYZ 200 2/5/2006
4 T TEV 750 3/8/2006

If A2 is "T" then highlight A2:D2. That means Row 1 and Row 4 will be highlighted, not just cell A2.
 
Upvote 0
Click on A2 and select down to D4 (or wherever). Use Conditional Format -->

Formula Is: =$A2="T"

The "$" makes the whole row check column A for the condition.
 
Upvote 0
If you highlight A1:D20 when you enter the conditional format, not just A1:A20, it should fix it.
 
Upvote 0

Forum statistics

Threads
1,217,676
Messages
6,137,934
Members
450,099
Latest member
Pushbutton

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
Back
Top