Conditional Formatting
 

Hi.

I want to be able to highlight a Row on my spreadsheet when one of the cells
contains the word "Yes".

I have tried a variety of things, including the Conditional Formatting
wizard but cant get it to work.

My Spreadsheet has the following columns:

A = Name, B = Attending, C = Deposit Paid, D = Balance Paid, E = Total Paid.

If Column B has Yes in it, I want the all 5 cells in the table to highlight
in a different colour.

Thanks in advance,
Steve.

Conditional Formatting
 

Assuming you don't want to highlight each cell in the same row a different
color (a rainbow across)
Highlight your data (A2:E whatever), this will make your 'active cell' cell A2
Conditional Formatting, change the drop down to Formula is
=$B2="Yes" then select your color
If you DO want each cell in the same row to be a different color when column
B is yes, then the same principal applies, just do your selections 1 at a
time, A2:A100, B2:B100, etc..., but always remember to have the dollar sign
before the column, but not before the row.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"FBxiii" wrote:

Hi.

I want to be able to highlight a Row on my spreadsheet when one of the cells
contains the word "Yes".

I have tried a variety of things, including the Conditional Formatting
wizard but cant get it to work.

My Spreadsheet has the following columns:

A = Name, B = Attending, C = Deposit Paid, D = Balance Paid, E = Total Paid.

If Column B has Yes in it, I want the all 5 cells in the table to highlight
in a different colour.

Thanks in advance,
Steve.

Conditional Formatting
 

Ahhh, I see :)

I was using $B$4 as my row. When I entered yes on the first row, they were
all highlighting. Ive got it now, thanks :)



"John C" wrote:

Assuming you don't want to highlight each cell in the same row a different
color (a rainbow across)
Highlight your data (A2:E whatever), this will make your 'active cell' cell A2
Conditional Formatting, change the drop down to Formula is
=$B2="Yes" then select your color
If you DO want each cell in the same row to be a different color when column
B is yes, then the same principal applies, just do your selections 1 at a
time, A2:A100, B2:B100, etc..., but always remember to have the dollar sign
before the column, but not before the row.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"FBxiii" wrote:

Hi.

I want to be able to highlight a Row on my spreadsheet when one of the cells
contains the word "Yes".

I have tried a variety of things, including the Conditional Formatting
wizard but cant get it to work.

My Spreadsheet has the following columns:

A = Name, B = Attending, C = Deposit Paid, D = Balance Paid, E = Total Paid.

If Column B has Yes in it, I want the all 5 cells in the table to highlight
in a different colour.

Thanks in advance,
Steve.

Conditional Formatting
 

Thank you for the feedback :)
--
** John C **


"FBxiii" wrote:

Ahhh, I see :)

I was using $B$4 as my row. When I entered yes on the first row, they were
all highlighting. Ive got it now, thanks :)



"John C" wrote:

Assuming you don't want to highlight each cell in the same row a different
color (a rainbow across)
Highlight your data (A2:E whatever), this will make your 'active cell' cell A2
Conditional Formatting, change the drop down to Formula is
=$B2="Yes" then select your color
If you DO want each cell in the same row to be a different color when column
B is yes, then the same principal applies, just do your selections 1 at a
time, A2:A100, B2:B100, etc..., but always remember to have the dollar sign
before the column, but not before the row.
--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"FBxiii" wrote:

Hi.

I want to be able to highlight a Row on my spreadsheet when one of the cells
contains the word "Yes".

I have tried a variety of things, including the Conditional Formatting
wizard but cant get it to work.

My Spreadsheet has the following columns:

A = Name, B = Attending, C = Deposit Paid, D = Balance Paid, E = Total Paid.

If Column B has Yes in it, I want the all 5 cells in the table to highlight
in a different colour.

Thanks in advance,
Steve.