I want to conditionally format a cell if a different cell has contains
certain data. I only know how to do this based on the selected cells
contents. Can anyone help?
I want to conditionally format a cell if a different cell has contains
certain data. I only know how to do this based on the selected cells
contents. Can anyone help?
Format / CF / Change 'Cell Value is' to 'Formula is' and then use normal
formulas with cell references.
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
"Confused" <[email protected]> wrote in message
news:[email protected]...
> I want to conditionally format a cell if a different cell has contains
> certain data. I only know how to do this based on the selected cells
> contents. Can anyone help?
To CF A1 when B1 is equal to "confused".......
Select A1 then Format>CF>Formula is:
=B1="confused"
Pick a format and OK your way out.
Gord Dibben Excel MVP
On Mon, 10 Jan 2005 12:05:04 -0800, "Confused"
<[email protected]> wrote:
>I want to conditionally format a cell if a different cell has contains
>certain data. I only know how to do this based on the selected cells
>contents. Can anyone help?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks