F
Frank Kabel
Hi
no VBA required
for example try the following:
- select cells A1:X1
- goto 'Format - Conditional format
- enter the following formula
=A1=$X1
- choose a format
this checks if the cell value in the range A1:X1 is equal
to cell X1 and if yes highlights it
instead of conditonal formatting ONE cell, I want the
entire row to be formatted to my liking.
no VBA required
for example try the following:
- select cells A1:X1
- goto 'Format - Conditional format
- enter the following formula
=A1=$X1
- choose a format
this checks if the cell value in the range A1:X1 is equal
to cell X1 and if yes highlights it
locate a solution (or I'm not searching hard enough).
on an entry in a single cell in the same row. Basically,
instead of conditonal formatting ONE cell, I want the
entire row to be formatted to my liking.