How does your data designate gender?

M/F?
Male/Female?
some other code?

So long as the data contains info that allows you to differentiate, just use
Conditional Formatting

Let's say the first row of data you want to address is in row 2, and that
the male/female code is in column F

Select cell A2 then highlight the entire range of data - all rows & columns
Go to Format-Conditional formatting
Select 'Formula is' and use
=$g2= "M" (or "Male" or other code)
Click on the format button and choose your fromatting atttributes
OK your way back to the Conditional Formatting dialog
Click on the Add button
Duplicate the previous steps, exect the formula is
=$g2="F"

"Jennifer" wrote:

I have a chart listing year of degree and title with salary information, I
would like to now color code the male and female different colors, how can I
do this?

--
Thanks!
-Jennifer