Apply conditional formatting to a row of a table the references

Resolved · Urgent Priority · Version 2010

Tue 30 Jul 2013, 10:00 Delegate Takaedza said...

Takaedza has attended:
Excel Intermediate course
Excel Advanced course

Apply conditional formatting to a row of a table the references

I have a table that is source from data in other worksheets and need to highlight a line based on the values in on of those cells. is that possible?

Tue 30 Jul 2013, 10:42 Trainer Doug said...

RE: Apply conditional formatting to a row of a table the referen

Hi Takaedza

Yes, conditional formatting looks at the values in the cell even if they are based on links to other worksheets or workbooks.

You can also create a formula rule that reference another worksheet (but not another workbook).

For example the following rule could highlight any differenced between sheet1 and sheet3 in a range of cells say A2:A100

=$A2<>Sheet3!$A2

Please say more about your question if it helps.

Doug
Best STL

Tue 30 Jul 2013, 10:48 Delegate Takaedza said...

RE: Apply conditional formatting to a row of a table the referen

Hi Doug,

Thanks for looking at this would it be possible for me to share the sheet with you so you can talk me through what I'm doing wrong?

Tue 30 Jul 2013, 10:58 Trainer Doug said...

RE: Apply conditional formatting to a row of a table the referen

Yes ok.

You can send your file to doug@stl-training.co.uk

If you add a note about which cells you are formatting it would help. We can speak on the phone if it's not clear.

Regards
Doug

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Move or Highlight Cells

Use any of your movement keys, cursor, Home, End, PgUp or PgDn to highlight cells rows or columns by holding down the Shift key as you move.

Use in combination with the Ctrl key for quicker movements.

View all Excel hints and tips