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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

gobias

New Member
Joined
Feb 23, 2006
Messages
18
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.
 

CJANG

New Member
Joined
Dec 26, 2005
Messages
3
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.
 

yee388

Well-known Member
Joined
Mar 7, 2004
Messages
1,374
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.
 

gobias

New Member
Joined
Feb 23, 2006
Messages
18
If you highlight A1:D20 when you enter the conditional format, not just A1:A20, it should fix it.
 

Forum statistics

Threads
1,141,718
Messages
5,708,070
Members
421,543
Latest member
SGM

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